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

user_5886503 0
Viewed 6222

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 !

laravel-5 laravel mysql php json
3 Answers

You can use not:

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

In Laravel 5.6.24 you can use whereJsonDoesntContain():

TABLE::whereJsonDoesntContain('list', 'value')->get();
user_48485870

list IS NULL OR JSON_CONTAINS(list, 'value') = 0

user_71567570
Related