json字段全查 SELECT * FROM your_table WHERE JSON_CONTAINS(json_field, '{"area":"A","column":3,"layer":3,"row":1}'); Mysql中json类型数据查询_mysql查询json数据-CSDN博客j