摘要： ```sql -- 替换json中数据 select SUBSTRING_INDEX(SUBSTRING_INDEX('[{"channelCode":"MOBIL","scale":1400000},{"channelCode":"WXMALL","scale":600000}]','},{',1),'scale":',-1); select replace('[{"channelCode" 阅读全文