laravel 7 return only specific fields code example

Example 1: laravel eloquent get only field name

//Eloquent: Get specific columns (not all the row). Pluck returns an array.
Model::where('id', 1)->pluck('name', 'surname');
// If you only want to get the result value:
Model::where('id', 1)->value('name');

Example 2: eloquest how to select one specific column in database

ModelName::where('a', 1)->get(['column1','column2']);

Example 3: eloquest how to select one specific column in database

ModelName::find($id, ['name', 'surname']);