orderBy field name in laravel query

Question

I want to order the query value based on status order 8,1,2,3,4,5,6,7.I have the query.Is is possible to sort by given value. I want to order the query result in the given order 8,1,2,3,4,5,6,7

$query->orderBy('status','DESC')  //order by 8,1,2,3,4,5,6,7
->get();

I want to order the query result in the given order 8,1,2,3,4,5,6,7 — user3386779, Nov 29 '17 at 07:04
You can play around with collection since you are ordering it with status first fetch the first record and in the for loop start from end till 2nd element — Rohit shah, Nov 29 '17 at 07:06
https://stackoverflow.com/questions/26704575/laravel-order-by-where-in — Casper, Nov 29 '17 at 07:06

score 3 · Accepted Answer · answered Nov 29 '17 at 07:05

3

you can use orderByRaw() method

answered Nov 29 '17 at 07:05

adrianriyadi

385
1
7
17

orderBy field name in laravel query

1 Answers1