/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

41 votes226 views6 answers
Alter table add column in SQL Server
SQL
4 votes214 views2 answers
Sql select except null
SQL
18 votes149 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote147 views1 answer
Mysql join same table multiple times group by
SQL
0 vote139 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote143 views1 answer
Oracle job class
SQL
0 vote139 views1 answer
Sql delete where x or y or z
SQL
0 vote146 views1 answer
Désinstaller postgresql linux
SQL
0 vote156 views2 answers
Import .sql into postgres db command
SQL
1 vote159 views1 answer
Describe table in sql
SQL