MySQL: Check if JSON array doesn’t contain a value

Suppose you have a table like this:

And you want to find all the records where user_types doesn’t contain the entry "CLIENT". You can do this with the below query:

SELECT *
FROM user
WHERE NOT JSON_CONTAINS(user_types, '"CLIENT"')