What is pluck in MySQL select query
in MySql, Tips and Tricks
Without pluck
$data['category'] = DB::table('table_name')->select('category', DB::raw('count(*) as total'))->groupBy('category')->where('date','>=',$start_date)->where('date','<=',$end_date)->get();
"category": [
{
"category": "Car",
"total": 2
},
{
"category": "vehicle",
"total": 1
}
],
With pluck
$data['category'] = DB::table('table_name')->select('category', DB::raw('count(*) as total'))->groupBy('category')->where('date','>=',$start_date)->where('date','<=',$end_date)->pluck('total','category')->all();
"category": {
"Car": 2,
"vehicle": 1
}
Related