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'; 
posted @ 2023-01-04 09:27  夜旦  阅读(232)  评论(0编辑  收藏  举报