mysql json 查询

select * from 72craft_system.logdetails where LogFROM ='同步店铺数据'
and JSON_CONTAINS(JSON_EXTRACT(jsonstr, "$.cp_retailer_store") ,JSON_OBJECT("store_no","STR4012","state_code","CO"))

jsonstr是两个json 数组

先获取cp_retailer_store 的数据 .

再看其中是否包含 "store_no"="STR4012" 并且"state_code"="CO"