I have JSON
type column named medium
in my table
one of the field value like ["art", "nature"]
I want to get the rows with equivalent like query WHERE
medium LIKE %art%`
Refered this links but can't find a proper solution for this
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html