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