1.一维数组查询
select * from users where json_extract(address, '$.province') = "河北省";
其中address是数据表字段,province是json字段
2.二维数组查询
select * from user where JSON_CONTAINS(address,JSON_OBJECT('phone', '13093676014'))
3.二维数组模糊查询
select * from user where JSON_EXTRACT(address, '$[*].phone') LIKE '%130%'