Laravel - Get specific rows first from db

Question

So I want to "fix" the first three results in my array, that I get from my be so here is my example:

$ids = explode(',', '2,3,1');

$result = Items::whereIn('id', $ids)
                    ->where('active', '1')
                    ->get();

So I want this to return an array where the id 2 is the first, then 2, then 1. The order of the id's will be determent different each time, so I can't do something like order by id etc.

take a look at this: http://stackoverflow.com/questions/866465/order-by-the-in-value-list — Mubashar Abbas, Mar 30 '17 at 08:06

score 2 · Accepted Answer · answered Mar 30 '17 at 08:44

2

Use Raw for FIELD

$result = Items::whereIn('id', $ids)
                    ->where('active', '1')
                    ->orderByRaw('FIELD(id,$ids)')
                    ->get();

answered Mar 30 '17 at 08:44

Mihai

26,325
7
66
81

Laravel - Get specific rows first from db

1 Answers1