字典嵌套数组格式处理

form_data列值如下：

{"textarea_11": "123", "imgupload": [{"key": "1655089936494_94427", "url": "http://192.168.1.129:99/static/uploadfile/images/aa.jpg", "percent": 100}]} 

查url

select form_data->'$.imgupload[0].url',id from mysqltable where form_data like '%99%' ;

更新aa.jpg改成bb.jpg

update mysqltable set form_data=json_replace(form_data,'$.imgupload[0].url',"http://192.168.1.129:99/static/uploadfile/images/bb.png)") where id=xx;