vendredi 5 mai 2017

JSON Where Clause on array of values with Query Builder

Here is a JSON value in a data column of a things table:

{a: [{b: 1}, {b: 2}]}

I can get all things containing a b that is equals to 1 with a raw query like this:

select * from things where data @> '{ "a": [{"b": 1}] }';

I know we can run query with Laravel with JSON where clause with Laravel: http://ift.tt/2pGTYbT. I can write something like:

Thing::where('a->c', 'foobar');

But can I write a where to check if a contains {b: 1} just like in the raw query with Laravel's Query Builder?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire