mysql5.7对json字段查询
{
"data": {
"shipper": {
"address": "No.236 Qianwangang Road,West Coast New Area",
"province": "SHANDONG",
"city": "QINGDAO",
"countryCode": "CN",
"district": "HUANGDAO",
"mobile": "15865564428",
"name": "ChiDongfang",
"company": "RRS SUPPLY CHAIN TECHNOLOGY CO LTD",
"postCode": "266599"
},
"pickUpTimeStart": "2022-09-16 17:00:00",
"pickUpTimeEnd": "2022-09-16 19:00:00"
},
"clientExpressCode": "DHLN",
"expressCode": "DHL",
"type": "pickUp"
}
SELECT Request FROM rrs_oms_v2.DHLPickUp where json_extract(Request,"$.expressCode") = 'DHL';
三分热血值得你十二分努力。