Laravel eloquent find in array of objects column

Question

I have a table called services with multiple columns and one column named staff_assigned with this content:

[{"user_id":"15549","price":"100"},{"user_id":"15548","price":"300"},{"user_id":"15552","price":"95"},{"user_id":"15553","price":"600"}]

How can I find all services where user_id is 15548 with Laravel eloquent?
Note that

Service::where('staff_assign->user_id', "15548")->get();

doesn't work because column contains array of objects.

Thank you!

pr1nc3 · Accepted Answer · 2022-10-12 15:03:05Z

1

Maybe you can try this:

->whereJsonContains('staff_assign',  ['user_id' => '15548'])

answered Oct 12, 2022 at 15:03

pr1nc3

8,3763 gold badges27 silver badges40 bronze badges

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

Comments

Elliot Putt · Accepted Answer · 2022-10-12 15:00:21Z

0

Service::where('user_id', '=' , "15552")->get();

Just add the '=';

answered Oct 12, 2022 at 15:00

Elliot Putt

12 bronze badges

user_id is not column. staff_assign is column with array of objects.