- 方法一:
精确匹配
SELECT * FROM `t_prop_unit` tp WHERE JSON_CONTAINS(c_unit_leader,json_object('name','测试'))
- 方法二:
模糊匹配
SELECT * FROM `t_prop_unit` tp WHERE json_extract(c_unit_leader,"$[*].name") like '%测试%'
SELECT * FROM `t_prop_unit` tp WHERE JSON_CONTAINS(c_unit_leader,json_object('name','测试'))
SELECT * FROM `t_prop_unit` tp WHERE json_extract(c_unit_leader,"$[*].name") like '%测试%'