/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 vote207 views1 answer
Sql query to get column names and data types in sql server
SQL
6 votes187 views2 answers
Find mysql version linux
SQL
4 votes207 views1 answer
SQL find text in SP
SQL
0 vote227 views1 answer
Insert output identity
SQL
5 votes269 views1 answer
Purge undo tablespace oracle 11g
SQL
9 votes187 views3 answers
Where in sql
SQL
0 vote217 views1 answer
Pgadmin check database
SQL
9 votes193 views4 answers
Add primary key to existing table sql
SQL
0 vote256 views1 answer
Mysql workbench not showing schemas
SQL
0 vote191 views1 answer
Sql server inner join convert collation
SQL