Laravel model: query from multiple array

Question

I have a db table Pharmacy which has a column area, which is an array.

so for pharmacy id=1 lets say area = [10,12]
for pharmacy id=2 say area = [1,2]
for pharmacy id=3 say area = [1,10]

I want to make an eloquent query which will search through all the data rows of pharmacy table and return only those pharmacy id which has area=10

In return I should get id = [1,3]

How do I do this using eloquent query?

Davit Zeynalyan · Accepted Answer · 2021-10-31 10:36:55Z

2

Use https://laravel.com/docs/8.x/queries#json-where-clauses

$pharmacies  = Pharmacy::whereJsonContains('area', 10)
                ->pluck('id);

answered Oct 31, 2021 at 10:36

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Laravel model: query from multiple array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related