SELECT
SUBSTRING_INDEX(address, ' ', 1) AS '省',
SUBSTRING_INDEX(SUBSTRING_INDEX(address, ' ', 2), ' ', -1) AS '市',
SUBSTRING_INDEX(SUBSTRING_INDEX(address, ' ', 3), ' ', -1) AS '区',
addressdetail,
FROM
address
转载于:https://my.oschina.net/shmilyle/blog/1927208