mysql SUBSTRING_INDEX
文章目录
SELECT hi.houseCode,SUBSTRING_INDEX(hi.houseCode,'-',1) AS lou,SUBSTRING_INDEX(SUBSTRING_INDEX(hi.houseCode,'-',2),'-',-1) AS men,SUBSTRING_INDEX(hi.houseCode,'-',-1) AS fang FROM houseinfo hi

SELECT hi.houseCode,SUBSTRING_INDEX(hi.houseCode,'-',1) AS lou,SUBSTRING_INDEX(SUBSTRING_INDEX(hi.houseCode,'-',2),'-',-1) AS men,SUBSTRING_INDEX(hi.houseCode,'-',-1) AS fang FROM houseinfo hi

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论