Can I somehow check in the query whether the value is in the array, which is written in the table?

Question

Laravel

Hello. In one of the columns of the table, there is an array of the form

{"query":"true","city_id":["4","5","6"],"country":["2"]}

The city_id value comes in. In the view query constructor, ->where('a', 'b');you can somehow check whether this incoming value falls into this array, by the key city_id?

Answer 1

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

Answer 2

Rule - Exists