Select Specific Columns in Laravel Eloquent Model?

Introduction

Hey there! Are you struggling with selecting specific columns in Laravel Eloquent Model? Well, fret not, because I’m here to guide you through the process step by step. In this article, we will explore different techniques and methods to select only the columns you need from your database using Laravel’s powerful Eloquent ORM.

Understanding Eloquent Model

Before we dive into the details, let’s quickly recap what Eloquent Model is all about. In Laravel, Eloquent is the default ORM (Object Relational Mapping) that provides an intuitive and expressive syntax for interacting with your database. It allows you to work with database tables as objects, making database operations a breeze.

The Problem

Often, when working with large databases, you may find yourself in a situation where you only need to retrieve specific columns from a table, rather than fetching all the columns. This can be particularly useful when dealing with large datasets or optimizing performance.

Using the “select” Method

* mark is use for all data get from addprofiles

$data = addprofiles::select('addprofiles.file_pic', 'addprofiles.*')->get();

Using the “addSelect” Method

$data = addprofiles::query()
    ->addSelect(['addprofiles.file_pic', 'addprofiles.*'])
    ->addSelect(['addprofiles.facebook', 'addprofiles.twitter'])
    ->get();

Using the “selectRaw” Method

 $data->selectRaw("GROUP_CONCAT(DISTINCT payments.face_price) AS face_price");

Conclusion

By now, you should have a good understanding of how to select specific columns in Laravel Eloquent Model. We have explored different techniques and methods, such as the “select” method, “addSelect” method, and “selectRaw” method, that allow us to fetch only the columns we need from the database.