Using JSON_CONTAINS in MySQL query gets not result

user_3765165 0
Viewed 899

I want a query to return all the fields for all the entries in the table minto_regsix_session that include a value of 2 in the 'day' field. Following is a screenshot from phpMyAdmin of the table including the day field which contains a JSON array.

This is the data in the MySQL table

This is the mysql query I'm using:

SELECT * 
FROM `minto_regsix_session` 
WHERE JSON_CONTAINS(`day`, '2') = 1

The query returns an empty result. I would expect it to return the data from lines 2, 4, and 5. Why doesn't this work?

mysql json
1 Answers
SELECT * 
FROM `minto_regsix_session` 
WHERE JSON_CONTAINS(`day`, '"2"');
user_101387340
Related