Toast3
0
Q:

eloquest how to select one specific column in database

Model::where('id', 1)
         ->pluck('name', 'surname')
         ->all();
1
//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');
0
   $result = DB::Table('table_name')->select('column1','column2')->where('id',1)->get();  
0
ModelName::where('a', 1)->get(['column1','column2']);
0
ModelName::find($id, ['name', 'surname']);
0

New to Communities?

Join the community