Question 17680 in Laravel Question posted in
The official Laravel Documentation can be found here.

Laravel eloquent find in array of objects column

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!

Tags:

2

Answers


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

    Just add the ‘=’;

    Login or Signup to reply.
  2. 0

    Maybe you can try this:

    ->whereJsonContains('staff_assign',  ['user_id' => '15548'])
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search