标签：00 DHL mysql5.7 09 Request 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';
标签：00,
DHL,
mysql5.7,
09,
Request,
json,
字段
From： https://www.cnblogs.com/woooodlin/p/17023950.html