mysql查询语句数组下标截取
#["广东省","汕头市","龙湖区"]
SELECT a.`register_address` AS 工商地址,a.`dismantle_address`,
REPLACE (dismantle_address->'$[0]','"','') AS 省
,REPLACE (dismantle_address->'$[1]','"','') AS 市
,REPLACE (dismantle_address->'$[2]','"','') AS 区
FROM `optimus_pevc`.`project_business` a ORDER BY a.id DESC;
数据库