查询隧道数据里面的字段的值

隧道数据里面存放了{“incomeType”,“2423423”}这样的字符串，使用REPLACE(JSON_EXTRACT(e.TUNNELDATA, ‘$.incomeType’),’"’,’’)求得“2423423”

select b.BP_NO, REPLACE(JSON_EXTRACT(e.TUNNELDATA, '$.incomeType'),'"','') AS INCOME_TYPE,
               REPLACE(JSON_EXTRACT(e.TUNNELDATA, '$.productServiceCode'),'"','') AS PRODUCT_SERVICE_CODE
               from cs_settlement_bill b, cs_settlement_bill_ext e

 `TUNNELDATA` varchar(2048) DEFAULT NULL COMMENT '隧道数据',