/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

0 vote196 views1 answer
How to output a different column name in mysql
SQL
12 votes205 views2 answers
Delete all entries postgres
SQL
-1 vote222 views3 answers
How to restart mysql in linux
SQL
0 vote171 views1 answer
Mysql timeout 30 seconds
SQL
0 vote192 views1 answer
Sql from null to not null
SQL
0 vote210 views1 answer
Sql alter column name sql server
SQL
3 votes205 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote211 views2 answers
How to get json data mysql
SQL
2 votes202 views1 answer
Set column to not null mysql
SQL
3 votes194 views2 answers
How to View column names of a table in SQL
SQL