How to get results based on elements in array with laravel whereIn?

Question

I have an array like this

$products = [350, 410, 362, 256, 193]

I have used this array to get results like this:

$searchResults = ProductSearch::whereIn('product_id', $products)->get();

In this result, I am not getting product with id 350 on first element in the result collection. Is there any way to achieve such result using ORM ?

You are already using ORM. Is this example not working for you? — NoOorZ24, Jul 25 '22 at 06:25
@NoOorZ24 yes I want result in an order similar to the above array ! — Sagar Gautam, Jul 25 '22 at 06:32

mcky · Answer 1 · 2022-07-25T10:28:46.973

0

Unless you specify ORDER BY in an sql query, the order is undefined.

To define an order from your array, use `orderByRaw()`

$products = [350, 410, 362, 256, 193]
 
$products_ordered = implode(',', $products);
 
$items = ProductSearch::whereIn('product_id', $products)
 ->orderByRaw("FIELD(product_id, $products_ordered)")
 ->get();

The order issue is not a Laravel issue, but an SQL issue. Read this question, where someone is having the same issue without Laravel. And these almost identical questions:

edited Jul 25 '22 at 10:28

answered Jul 25 '22 at 04:21

mcky

823
2
7
20

I have used this approach using ORM, but results are not as expected ! – Sagar Gautam Jul 25 '22 at 06:34
Please update your question with the current returned output and the expected output. – mcky Jul 25 '22 at 06:36
There is specific order right now, I want recrod with product_id = 350 at first and then 410 & so on ! – Sagar Gautam Jul 25 '22 at 06:39

score 0 · Answer 2 · answered Jul 25 '22 at 06:27

0

Have you checked that your table has a column( product_id ) available?

answered Jul 25 '22 at 06:27

Jaimini Solanki

24
2

Yes, that column exists ! – Sagar Gautam Jul 25 '22 at 06:31
and also 350 ID available or not? – Jaimini Solanki Jul 25 '22 at 06:37
ID is available, and records are not in order of above array ! – Sagar Gautam Jul 25 '22 at 06:38
You can check it by using $searchresult = DB::table('productSearch')->whereIn('product_id', $products)->get(); – Jaimini Solanki Jul 25 '22 at 06:42
Have tried that one, still not working ! – Sagar Gautam Jul 25 '22 at 06:49

How to get results based on elements in array with laravel whereIn?

2 Answers2

To define an order from your array, use orderByRaw()

To define an order from your array, use `orderByRaw()`