How to Select Certain Fields in Laravel Eloquent?

Question

How to Do following Query in Laravel Eloquent?

SELECT catID, catName, imgPath FROM categories WHERE catType = "Root"

I have tried following

CategoryModel::where('catType', '=', 'Root')
                ->lists('catName', 'catID', 'imgPath');

but its return only two fields.

Array ( [7] => Category 1 )

Answer 1

From laravel version 5.3^ lists() is deprecated and function pluck() is used instead.

pluck() returns a collection and if you need a simple array just prepend ->toArray() to it.

Answer 2

lists() turns the resulting collection into an array with key value. You can only have two database columns in there. Otherwise you have to use select() but then you will get a collection of models not just an array.

$categories = CategoryModel::select('catID', 'catName', 'imgPath')
                           ->where('catType', '=', 'Root')
                           ->get();

Answer 3

CategoryModel::wherecatType('Root')
            ->pluck('catName', 'catID', 'imgPath');

Answer 4

Selecting multiple columns

CategoryModel::get(['catName', 'catID', 'imgPath']);

Works with Laravel 5.3 too!