Laravel Order By Multiple Columns Example

By Hardik Savani October 3, 2022 Category : Laravel

Hey Guys,

Today, I would like to show you laravel order by multiple columns. step by step explain how to order by multiple columns in laravel. I explained simply about how to order by two columns in laravel. This article goes in detailed on how to use multiple order by in laravel.

You can use this example with laravel 6, laravel 7, laravel 8 and laravel 9 versions.

There are several ways to order by with multiple columns in laravel eloquent. i will give you two simple examples using orderBy() and orderByRaw() eloquent method to multiple column order by with "ASC" and "DESC".

So, let's see the simple code example:

Example 1: Using orderBy()

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Post;

class PostController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

$posts = Post::select("*")

->orderBy('created_at', 'ASC')

->orderBy('status', 'DESC')

->get();

dd($posts);

}

}

Example 2: Using orderByRaw()

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Post;

class PostController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index(Request $request)

{

$posts = Post::select("*")

->orderByRaw("created_at ASC, status DESC");

->get();

dd($posts);

}

}

I hope it can help you...

Tags :