Group By Eloquent ORM

I was searching for making a `GROUP BY name` [Eloquent ORM docs][1] but I haven't find anything, neither on google.

Does anyone know if it's possible ? or should I use query builder ?


[1]:

[To see links please register here]

Eloquent uses the query builder internally, so you can do:

$users = User::orderBy('name', 'desc')
->groupBy('count')
->having('count', '>', 100)
->get();

try: ```->unique('column') ```

example:

``` $users = User::get()->unique('column');```

# Laravel 5

> **WARNING**: As @Usama stated in comments section, this groups by AFTER fetching data from the database. The grouping is not done by the database server.
_I wouldn't recommend this solution for large data set._


This is working for me (i use **laravel 5.6**).

$collection = MyModel::all()->groupBy('column');

If you want to convert the collection to plain php array, you can use **toArray()**

$array = MyModel::all()->groupBy('column')->toArray();