/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 vote274 views1 answer
Cast as decimal postgresql
SQL
0 vote296 views1 answer
Add created and updatedAt fields in mysql
SQL
8 votes308 views3 answers
Postgres database sizes
SQL
1 vote278 views1 answer
Copy postgres table from one schema into another
SQL
0 vote267 views1 answer
Update set with inner join oracle
SQL
2 votes269 views2 answers
Compare date mysql
SQL
13 votes310 views4 answers
What is sql
SQL
1 vote279 views2 answers
Postgresql get difference in hours between two dates
SQL
1 vote277 views3 answers
How to get date in sql
SQL
4 votes290 views2 answers
Installing sql on ubuntu
SQL