jeudi 1 juin 2017

How to check the MySQL JSON column is not contains the value in laravel?

I used to find whether the searching item is exist in the JSON datatype column or not.

I use,

 TABLE::whereRaw('json_contains(list, \'["value"]\')')->get();

this to return those are having the "value" in "list" JSON column.

But, how can i use reverse method to list, those are not having this value in json column in laravel.

Thank you !



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire