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.