mysql 解析json数组的数组

数据库中字段：purchaseSectionInfo_1 对应的json数据为：

[
    {
        "winningbidderInfo":[
            {
                "scoreResult":"1",
                "CONTRACT_AMOUNT":32998000,
                "OTHER_BID_PRICE":"156",
                "PRICE_FORM_CODE":"1",
                "CONTRACT_CURRENCY":"156",
                "winningbidderCode":"91530100778553407U",
                "winningbidderName":"xxxxx有限责任公司",
                "winningbidderorder":1,
                "purchaseSectionCode":"0637-194001020728-1",
                "winningbidderAddress":"xxxx有限责任公司的地址不了解",
                "CONTRACT_CURRENCYUNIT":"0"
            }
        ],
        "purchaseSectionCode":"0637-xxxxx-1"
    }
]

需求，以purchaseSectionInfo_1为条件，查找这个字段内：winningbidderCode=’91530100778553407U’的行，经过多次测试，最终的SQL语句如下：

SELECT * FROM myTableName where 
JSON_EXTRACT(JSON_EXTRACT(purchaseSectionInfo_1,'$[*].winningbidderInfo[*].winningbidderCode'),"$[0]")
='91530100778553407U';