Laravel eloquent find in array of objects column-CodePudding

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!

CodePudding user response：

Maybe you can try this:

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

CodePudding user response：

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

Just add the '=';