/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

4 votes250 views1 answer
Search column by name mysql
SQL
0 vote222 views1 answer
How to get all values in a table mysql in c#
SQL
2 votes243 views1 answer
Can you use a where clause for a child query
SQL
-1 vote250 views2 answers
Create temporary table sql
SQL
1 vote241 views1 answer
Woocommerce mysql price table
SQL
0 vote257 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote256 views1 answer
How to find symmetric pairs in sql
SQL
0 vote253 views1 answer
Left join vs inner join performance
SQL
0 vote249 views1 answer
Acutal month year
SQL
1 vote227 views1 answer
Select 2 rows in sql
SQL