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)
Recommended:- Laravel Where Multiple Condition
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
Recommended:- Laravel – whereIn Eloquent Query Example
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 PHP Artisan Serve Not Working
Recommended:-Laravel Get Record Last Week, Month, 15 Days, Year
Recommended:-Laravel where Day, Date, Month, Year, Time, Column
Recommended:-Laravel Try Catch
Recommended:-Laravel Eloquent whereRaw Query Example
Recommended:-How to Get Random Records in Laravel
Recommended:-Laravel Clear Route, Config and View Cache Commands
Recommended:-Laravel InsertOrIgnore Example
Recommended:-Laravel whereIn, whereNotIn With SubQuery Example
Recommended:-Laravel Eloquent withSum() and withCount() Tutorial
Recommended:-Laravel Where Null and Where Not Null Query
Recommended:-Laravel Eloquent firstWhere() Example
Recommended:-Laravel Group by Example
Recommended:-Laravel Order by Example
Recommended:-Laravel 8 Google Autocomplete Address Tutorial
Recommended:-Laravel 8 Vue JS Post Axios Request Tutorial
Recommended:-Laravel 8 Vue JS File Upload Tutorial Example
Recommended:-Laravel 8 Vue JS Live Search Example
Recommended:-Laravel 8 Vue Js Infinity Page Scroll Example
Recommended:-How to implement Datatables with Vuejs And Laravel 8
Recommended:-Laravel 8 Google Autocomplete Address Tutorial
Recommended:-Laravel 8 Vue JS CRUD App
Recommended:-Vue JS And Laravel 8 Like Dislike Tutorial Example
