Laravel orderByRaw() Query Example

Laravel orderByRaw() Query Example

orderByRaw() query in laravel; In this tutorial, you will learn in detail how to write and use query using orderByRaw(), select raw and select DB raw in laravel with eloquent join.

You can use the laravel orderByRaw eloquent method to building query in laravel apps. And also use laravel select raw with multiple conditions in eloquent queries.

So, let’s see the following examples that will help you on how to use orderByRaw() eloquent query in laravel:

  1. Example 1: Laravel OrderByRaw Query using Model
  2. Example 2: orderByRaw Query using Query Builder
  3. Example 3: Laravel orderByDesc() Example

Example 1: Laravel OrderByRaw Query using Model

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $users = User::select("*")
                        ->where("status", 1)
                        ->orderByRaw("concat(first_name, ' ', last_name)")
                        ->get();
  
        dd($users);
    }
}

Dump the above given orderByRaw query you will get the following SQL query:

select * from `users` 

    where `status` = ? 

    order by concat(first_name, ' ', last_name)

Example 2: orderByRaw Query using Query Builder

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $users = DB::table('users')->select("*")
                        ->where("status", 1)
                        ->orderByRaw("concat(first_name, ' ', last_name) DESC")
                        ->get();
  
        dd($users);
    }
}

Dump the above given orderByRaw query you will get the following SQL query:

select * from `users` 

    where `status` = ? 

    order by concat(first_name, ' ', last_name) DESC

Example 3: Laravel orderByDesc() Example

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $users = User::select("*")
                        ->where("status", 1)
                        ->orderByDesc("name")
                        ->get();
  
        dd($users);
    }
}

Dump the above given orderByRaw query you will get the following SQL query:

select * from `users` 

    where `status` = ? 

    order by `name` desc

Recommended Laravel Tutorials

Recommended:-Laravel Try Catch

AuthorAdmin

My name is Devendra Dode. I am a full-stack developer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Express JS, Vue JS, Angular JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting stage. As well as demo example.

Leave a Reply

Your email address will not be published. Required fields are marked *