mysql查询字段为json，数据为数组时，条件的写法

格式为

id data
1 [“joy”,“mike”]
2 [“nini”, “jack”]

查询data字段里有jack的数据

select * from tb where  JSON_CONTAINS(data->'$[*]', '"jack"', '$')

SELECT * FROM teacher t 
INNER JOIN student s
ON JSON_CONTAINS(t.student_ids, CONVERT(s.id,CHAR)) = 1

详细说明
https://blog.csdn.net/qq_21187515/article/details/90760337