How to Use Order By for Multiple Columns in Laravel

Question

Hii Everyone,

I want to sort multiple columns in Laravel  by using the method orderBy() in Laravel Eloquent. 

The query will be generated using Eloquent like this:

SELECT *
FROM mytable
ORDER BY
  coloumn1 DESC, coloumn2 ASC

How can I do this? Any help will be great!

Answer 1

Hii,

Use order by like this:

return User::orderBy('name', 'DESC')
    ->orderBy('surname', 'DESC')
    ->orderBy('email', 'DESC')
    ...
    ->get();

Hope it works!!