CODEWITHSUNDEEP
phplaraveleloquent
michael
michael

Reputation: 421

Laravel 7 eloquent whereIn and where not working

I have a record in my database that looks like this:

id | roles
----------
1  | ["test"]

I do this eloquent query:

UserModel::withTrashed()
      ->whereIn('roles', ['test'])
      ->where('id', 1)
      ->exists();

This returns false what am I doing wrong here?

Upvotes: 1

Views: 1057

Answers (1)

michael
michael

Reputation: 421

Apparently this exists:

->whereJsonContains('roles', ['test'])

Then it works great.

Upvotes: 1

Related Questions