Laravel does not give the values sequentially

Question

I have a car ids array.

$carIds = [21,12,33];

I'm sending an ids array to retrieve values from my collection.

$cars = Cars::whereIn('id', $carIds)->get();

Incoming car values do not come in the order of id I gave, it is complicated.

Because default sorting in database is done by id. You will have to sort to the wanted order manually. — Adrian Kokot, Nov 26 '21 at 09:59
Does this answer your question? [Maintaining order in MySQL "IN" query](https://stackoverflow.com/questions/1631723/maintaining-order-in-mysql-in-query) — ManojKiran A, Nov 26 '21 at 13:46

score 0 · Answer 1 · answered Nov 26 '21 at 10:14

0

update your code with below code

Cars::whereIn('id', $carIds)
->orderByRaw('FIELD (id, ' . implode(', ', $carIds) . ') ASC')
->get();

answered Nov 26 '21 at 10:14

yadu siva das

i am getting this error $meta is the only expression supported by $sort right now – Shakira Nov 26 '21 at 10:27
https://stackoverflow.com/questions/40731863/sort-collection-by-custom-order-in-eloquent – yadu siva das Nov 26 '21 at 10:31
check this question – yadu siva das Nov 26 '21 at 10:31

score 0 · Answer 2 · answered Nov 26 '21 at 10:37

0

Different way you can do is :

$cars = DB::table('Cars')
                ->orderBy('id', 'desc')
                ->get();

answered Nov 26 '21 at 10:37

bgeertsema2000

As the question clearly states that result must be in the order based on user provided ```ids``` – ManojKiran A Nov 26 '21 at 13:45

2 Answers2