/SQL/Eloquest how to select one specific column in database

Eloquest how to select one specific column in database

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');

Source: stackoverflow.com

Eloquest how to select one specific column in database

Model::where('id', 1)
         ->pluck('name', 'surname')
         ->all();

Source: stackoverflow.com

Eloquest how to select one specific column in database

   $result = DB::Table('table_name')->select('column1','column2')->where('id',1)->get();

Source: stackoverflow.com

Eloquest how to select one specific column in database

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

Source: stackoverflow.com

Eloquest how to select one specific column in database

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

Source: stackoverflow.com

Similar codes

1 vote183 views1 answer
Tsql find foreign key references
SQL
0 vote162 views1 answer
Name '_mysql' is not defined
SQL
0 vote185 views1 answer
Get the next column of a table in mysql
SQL
0 vote177 views1 answer
How to select all fieldsin a soql query
SQL
0 vote185 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote180 views1 answer
Update having mysql
SQL
0 vote178 views1 answer
Difference between min and max date sql
SQL
3 votes164 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
3 votes165 views2 answers
Oracle sql select all days between two dates except weekends
SQL
1 vote193 views1 answer
Trim leading zeros in sql
SQL