Ad

How To Perform A GroupBy In Laravel 5.8?

I have a table with 41 rows

I did

public function types()
{
    return DB::table('graphs')->groupBy('title')->get();
}

I kept getting

Can someone please help ?

I expected to get these 3

['MBN_PRIVATE','MBN_GUEST','SPWIFI'];
Ad

Answer

In MySql strict mode, you can't return non aggregated fields in a group by query. If you need only the title's values add a select or a pluck method

public function types()
{
    return DB::table('graphs')->groupBy('title')->pluck('title')->toArray();
}
Ad
source: stackoverflow.com
Ad