how to use where() with array in laravel eloquent

Question

I have a column like this :

and i've gotten this array

"specification" => array:3 [▼
    0 => "27"
    1 => "26"
    2 => "24"
  ]

how can I compare these two with eloquent like this :

SpecificationItemGroup::where('specification_items', [$request->specification])->get()

print your query and compare... may be [] is no need in where condition... — Antony Jack
– Antony Jack, Commented Aug 9, 2020 at 5:36
@hassan try this SpecificationItemGroup::where('specification_items', $request->specification)->get() — wadleo
– wadleo, Commented Aug 9, 2020 at 5:43

Basheer Kharoti · Accepted Answer · 2020-08-09 05:48:58Z

4

Since you're storing it as json encoded string, you should try encoding the array and compare it

SpecificationItemGroup::where('specification_items', json_encode($request->specification))->get()

answered Aug 9, 2020 at 5:48

Basheer Kharoti

4,3025 gold badges27 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1