Order by using multiple columns and manually array field in Laravel? DB::raw

https://www.itsolutionstuff.com/post/order-by-using-multiple-columns-and-manually-array-field-in-laravelexample.html

Order by using multiple columns and manually array field in Laravel?

By Hardik Savani January 25, 2016 Category : LaravelPlayUnmuteLoaded: 1.17%Fullscreen

If you want to sort multiple columns in Laravel by using orderBy(). Whenever you need to give multiple column in your query then you can use twice time orderBy() and give them. you can give multiple columns in laravel by following example :

Users Table :

id	site_id	sub_site_id	name	email
1	4	7	john	[e-mail]
2	3	4	ram	[e-mail]
3	4	2	ader	[e-mail]
4	3	1	jay	[e-mail]
5	4	1	yamee	[e-mail]

Multiple Columns OrderBy

$data = DB::table('users')    ->select('users.*')    ->orderBy('site_id', 'asc')    ->orderBy('sub_site_id', 'asc')    ->get();

Result :

id	site_id	sub_site_id	name	email
4	3	1	jay	[e-mail]
2	3	4	ram	[e-mail]
5	4	1	yamee	[e-mail]
3	4	2	ader	[e-mail]
1	4	7	john	[e-mail]

you can also give array in order by method, Laravel give facility to sort manual array in order by, following example through specific array in order by.

Result :

id	site_id	sub_site_id	name	email
3	4	2	ader	[e-mail]
1	4	7	john	[e-mail]
4	3	1	jay	[e-mail]
5	4	1	yamee	[e-mail]
2	3	4	ram	[e-mail]

we are using string in order by like pending, approved and rejected status then following example are useful.

$data = DB::table('users')    ->select('users.*')    ->orderByRaw(DB::raw("FIELD(status, 'Pending', 'Approved', 'Rejected')"))    ->get();

if you want to give ‘ASC’ or ‘DESC’ order in query then following example :

Read Also: Laravel - Orderby Random using rand() and DB::raw() example

$data = DB::table('users')    ->select('users.*')    ->orderByRaw(DB::raw("FIELD(sub_site_id, 2, 7, 1, 4) DESC"))    ->get();

Try this....