Level 55
@andyandy like this
User::orderByRaw('if(role = "Admin", 0, 1)')
->orderBy('registration_date')
->get();
Mar 2, 2022
2
Level 4
Sort by single value in the column, eloquent
I have roles (Developer, Admin, User, Support...).
I want to sort by "Admins" - put Admins at the beginning - but don't sort by other values (Developer, User...). Then sort for example by date of registration.
Preferably Eloquent. Or SQL. Not collections etc.
Level 4
@SilenceBringer Thanks!
Please or to participate in this conversation.