How to Use Order By for Multiple Columns in Laravel 4?

php laravel laravel-4 eloquent laravel-query-builder
Sophy picture Sophy · Jun 9, 2013 · Viewed 206.5k times · Source

I want to sort multiple columns in Laravel 4 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?

Answer

rmobis picture rmobis · Jun 9, 2013

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

Related questions

Laravel 4: how to "order by" using Eloquent ORM

Simple question - how do I order by 'id' descending in Laravel 4. The relevant part of my controller looks like this: $posts = $this->post->all() As I understand you use this line: ->orderBy('id', 'DESC'); But …

Read More
Select all from table with Laravel and Eloquent

I am using Laravel 4 to set up my first model to pull all the rows from a table called posts. In standard MySQL I would use: SELECT * FROM posts; How do I achieve this in my Laravel 4 model? See below …

Read More
How to alias a table in Laravel Eloquent queries (or using Query Builder)?

Lets say we are using Laravel's query builder: $users = DB::table('really_long_table_name') ->select('really_long_table_name.id') ->get(); I'm looking for an equivalent to this SQL: really_long_table_name AS short_…

Read More