/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 vote308 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
2 votes349 views1 answer
Tcl in sql
SQL
4 votes287 views3 answers
Sqlite show columns
SQL
6 votes295 views1 answer
Postgres get size of database
SQL
1 vote314 views3 answers
Mysql on delete set null
SQL
4 votes277 views2 answers
DB::transaction
SQL
5 votes300 views3 answers
Db begintransaction laravel
SQL
0 vote332 views1 answer
Mysql get first 2 characters of string
SQL
2 votes301 views1 answer
How to get non distinct values in sql
SQL
0 vote297 views1 answer
Import Data in MySQL without using any other software
SQL