/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

23 votes117 views6 answers
Create table sql server
SQL
0 vote106 views1 answer
Drop specific row postgresql
SQL
0 vote116 views1 answer
Mysql update even / odd rows
SQL
1 vote120 views1 answer
Mysql how to truncate table with foreign keys
SQL
5 votes123 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote115 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
10 votes109 views2 answers
Tsql merge example
SQL
19 votes119 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote141 views1 answer
Wordpress make wp user in db
SQL
5 votes125 views3 answers
Sql server utc to local
SQL