MySQL JSON array to used in "IN" clause?
I would expect a JSON function to work, rather than IN
. Something like:
SELECT stuff.nameFROM table_stuff stuff JOIN json_table jt ON JSON_CONTAINS(jt.data, CONVERT(stuff.id, char)) = 1;
I would expect a JSON function to work, rather than IN
. Something like:
SELECT stuff.nameFROM table_stuff stuff JOIN json_table jt ON JSON_CONTAINS(jt.data, CONVERT(stuff.id, char)) = 1;