用于从mysql中的json_encided列中查找值的sql？

Question

I have a column of json_encoded in my table and want to check a value exist or not in that column. What type of query should write?

Example: I have a column in which values are: ["1","2","3","4"] and I want to check through query that 1 exists or not.

Answer 1

Try:

SELECT * FROM `tableName` WHERE Column LIKE '%"1"%';