how to show only unique users by name in eloquent?

Is any way to get the unique users filter by name or email so to not show the users with same email for example in eloquent ?

Level 65

groupBy() and you're done?

1 like

Level 20

You want that the search on name retrieve only one "John" even if you have 10 "John" users ?

Level 1

yes exactly

Level 20

use ->first() to retrieve data.

Level 1

dosent work

Level 20

dosent work

Could you be more specific ?

Server has crashed ? You got a 404 error ? The code dropped your users table ?

Level 20

})->when($unique_name, function ($query) {
            return $query->>where('first_name',  'like',  '%'.$unique_name.'%')
    ->take(1);

Level 1

search to is not in the scope so it dosent work

Level 20

Updated with, I guess, the correct variable.

Please or to participate in this conversation.