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

clipboard.png


bingo727
33 声望2 粉丝

java web基础框架,hybrid App,项目管理,客户沟通