So I have a value saved in MySQL DB that's in the following format:
SELECT * FROM table WHERE jsonColumn IN '88'
You would be better looking for
SELECT * FROM `table` WHERE `jsonColumn` LIKE '%["88"]%'
This will ensure that when searching for
88, values such as
["188"] are not incorrectly returned. Also, are you sure you need EVERYTHING from the table? Generally,
SELECT * is not needed.
That having been said, it may be better to optimise your normalization so you're not storing JSON or serialized data. This will make your queries much more efficient and generally easier to work with, especially for more complex queries.