Mysql的json格式查询 Mysql5.7后新加了json格式sql如下 SELECT * FROM c02_customer where custom_columns -> '$.mobile'='123111122221' select * from 表名称 where 表字段 -> '$.json的key' = ‘json格式的value’