/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

16 votes214 views6 answers
Mysql find and replace
SQL
5 votes233 views2 answers
Oracle find all tables with column name
SQL
0 vote248 views2 answers
Start mysql server using docker
SQL
3 votes219 views1 answer
Kill mysql processlist in whose time more than 200
SQL
3 votes215 views3 answers
Sql current year
SQL
0 vote208 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
7 votes221 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
3 votes219 views2 answers
Postgres alter table owner
SQL
0 vote205 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote234 views1 answer
Compare subqueries oracle
SQL