How to sort a Laravel query builder result by multiple columns?

by

Simply invoke orderBy() as many times as you need it. For instance:

User::orderBy('name', 'DESC')
    ->orderBy('email', 'ASC')
    ->get();

Produces the following query:

SELECT * FROM `users` ORDER BY `name` DESC, `email` ASC

More Related Contents:

  1. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  2. Get Specific Columns Using “With()” Function in Laravel Eloquent
  3. How do I get the query builder to output its raw SQL query as a string?
  4. Laravel Eloquent Query Using WHERE with OR AND OR?
  5. Creating and Update Laravel Eloquent
  6. Get the Query Executed in Laravel 3/4
  7. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  8. Automatically deleting related rows in Laravel (Eloquent ORM)
  9. Get the Last Inserted Id Using Laravel Eloquent
  10. How to do this in Laravel, subquery where in
  11. How to insert multiple rows from a single query using eloquent/fluent
  12. Laravel – Eloquent or Fluent random row
  13. Laravel update model with unique validation rule for attribute
  14. Add a custom attribute to a Laravel / Eloquent model on load?
  15. Eloquent ORM Code Hinting in PhpStorm
  16. Laravel Eloquent Sum of relation’s column
  17. What does “Mass Assignment” mean in Laravel?
  18. Laravel Checking If a Record Exists
  19. How to exclude certains columns while using eloquent
  20. Laravel 5 hasMany relationship on two columns
  21. Laravel Recursive Relationships
  22. Laravel Eloquent – Attach vs Sync
  23. How to create a subquery using Laravel Eloquent?
  24. Eloquent model mass update
  25. Difference between Eloquent\Model::get() and all()
  26. Natural ORDER in Laravel Eloquent ORM
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. Find or Create with Eloquent
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment