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'; 

__EOF__

本文作者：夜旦
本文链接：https://www.cnblogs.com/woooodlin/p/17023950.html
关于博主：评论和私信会在第一时间回复。或者直接私信我。
版权声明：本博客所有文章除特别声明外，均采用 BY-NC-SA 许可协议。转载请注明出处！
声援博主：如果您觉得文章对您有帮助，可以点击文章右下角【推荐】一下。您的鼓励是博主的最大动力！