/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

3 votes301 views5 answers
No module named 'MySQLdb'
SQL
1 vote297 views1 answer
Mysql find most common value
SQL
0 vote265 views1 answer
Sql trigger to call stored procedure with parameters
SQL
14 votes280 views2 answers
Oracle add attribute to table
SQL
6 votes246 views1 answer
Sqlite foreign key
SQL
0 vote279 views1 answer
Pl/pgsql declare variable
SQL
0 vote268 views2 answers
How to display enum value sql server
SQL
0 vote265 views2 answers
How to check if sqlite table exists in nodejs
SQL
1 vote213 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote258 views1 answer
Restore backupfile discourse
SQL