/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

-2 votes173 views1 answer
Trunc in sql
SQL
1 vote119 views1 answer
Mysql select update same table
SQL
1 vote340 views1 answer
How to make a select in sql
SQL
3 votes120 views1 answer
Oracle sleep
SQL
0 vote248 views1 answer
Oracle convert int to date
SQL
14 votes118 views2 answers
How to auto increment in sql
SQL
0 vote118 views1 answer
Tsql default value when no value returned by query
SQL
40 votes184 views6 answers
Update table mysql
SQL
1 vote153 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
-1 vote131 views1 answer
Spring boot mysql connection properties
SQL