How to get all data and orderBy specific word. For example I have column name status. In the status is store for "Approved", "Pending","Rejected".
How can i sort the data like show all status "Pending" with descending order?
Asked
Active
Viewed 1,438 times
0
-
select (case status when status= 'Pending' then 1 when status= 'Rejected' then 2 when status= 'Approved' then 3 end) as new_order from table order by new_order asc – JYoThI May 16 '17 at 05:19
1 Answers
2
This might work:
$data= DB::table('table_name')
->orderby(DB::raw('case when status= "Pending" then 1 when status= "Rejected" then 2 when status= "Approved" then 3 end'))
->get();
References
Question in stackoverflow
Laravel Documentation
