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:
- Example 1: Laravel OrderByRaw Query using Model
- Example 2: orderByRaw Query using Query Builder
- 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