Query on Select2+multiple field

[Mr71]

I'm using select2 + multiple:
I'll give a simplified example:
- in object select tab: 1|Red|2|green|3|blue.
- field in the table -> 'color' varchar (255)
If in the object (select2 + multiple) I select (red and blue) in the 'color' field of table, ["1","3"] is stored, I think that's a json string!!.
At this point in a query I want to find (for example) all the records that have on this string (in field) the color set to "blue" ("3").
I try with json_extract and json_search statement but it returns me all the records or nothing.
In the real solution I'm actually developing i would like to use the field in an address book to insert some kind of tag and then use the contact based on the tags in specific parts of the database.
What is the mysql query to make this selection?!

[kev1n]

Would that work?

Code: Select all

WHERE your_column like '%3%'

[Mr71]

I made it too hard...
I had tried but not with the double "%" ...
it works! it works!

Thanks Kevin