/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 votes252 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote286 views1 answer
Mariadb set vertical output format
SQL
0 vote251 views1 answer
How to get inserted id in sql server
SQL
0 vote221 views1 answer
Connection error in mysql workbench
SQL
2 votes270 views1 answer
Find all triggers in database
SQL
11 votes281 views2 answers
Mysql set safe mode off
SQL
0 vote266 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote276 views1 answer
Rename constraint postgresql
SQL
0 vote276 views1 answer
Mysql aspas simples
SQL
0 vote258 views1 answer
Difference between varchar and varchar2
SQL