In this tutorial you will learn about the Laravel orderByRaw() Query Example and its application with practical example.
In this Laravel orderByRaw() query example tutorial I’ll show you how to create orderByRaw query in laravel. In this article you will also learn to implement and orderByRaw with joined table data. In this Laravel orderByRaw() query example I’ll demonstrate different use case of the laravel orderByRaw() query.
Laravel orderByRaw() Query Example
In step by step tutorial I’ll demonstrate following different examples of Laravel orderByRaw() Query.This will help you to understand the use of orderByRaw() eloquent query in laravel:
- Laravel OrderByRaw Query using Model
- orderByRaw Query using Query Builder
- Laravel orderByDesc() Example
Laravel OrderByRaw Query using Model
In this example I’ll show you the example of OrderByRaw Query with model.
Example:-
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<?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); } } |
The above given OrderByRaw Query you will get the following SQL query:
|
1 2 3 4 5 |
select * from `users` where `status` = ? order by concat(first_name, ' ', last_name) |
orderByRaw Query using Query Builder
In this example I’ll show you the example of OrderByRaw Query with Query Builder.
Example:-
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<?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); } } |
The above given OrderByRaw Query you will get the following SQL query:
|
1 2 3 4 5 |
select * from `users` where `status` = ? order by concat(first_name, ' ', last_name) DESC |
Laravel orderByDesc() Example
In this example I’ll show you the example of orderByDesc() Query.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<?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); } } |
The above given orderByDesc() Query you will get the following SQL query:
|
1 2 3 4 5 |
select * from `users` where `status` = ? order by `name` desc |
