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