mysql把表中某一字段拆分为多列
一：sql数据库截图
二：sql语句
SELECT id, house_no as '总称',
SUBSTR(house_no, 1, 4) AS '小区名称',
SUBSTR(house_no, -10, 3) AS '楼幢',
SUBSTR(house_no, 5, 3) AS '楼幢2',
SUBSTR(house_no, -7,3) AS '单元',
SUBSTRING(house_no,-4) AS '房间号'
FROM aa;
三：查询结果图