mysql 拆分字符串

mysql 拆分字符串

二、拆分成2段

字段内容aaa,bbb

SELECT title, logopath, link, LEFT( info, (INSTR( info, ',' ) -1 )) AS info1, SUBSTRING( info, (INSTR( info, ',' ) +1 )) AS info2 FROM site_photo_info WHERE Pclass = '991' order by  addtime desc

 

二、拆分成3段

字段内容aaa,bbb,ccc

SELECT title, logopath, link,LEFT( info, (INSTR( info, ',') -1 )) AS info1, LEFT( SUBSTRING(info, (INSTR( info, ',') +1 )), (INSTR( SUBSTRING(info, (INSTR( info, ',') +1 )), ',') -1 )) AS info2, SUBSTRING(SUBSTRING(info, (INSTR( info, ',') +1 )), (INSTR(SUBSTRING(info, (INSTR( info, ',') +1 )), ',') +1 )) AS info3 FROM site_photo_info WHERE Pclass = '993' AND owner =1 ORDER BY addtime DESC"

posted on 2011-11-04 15:50 wnguh 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/591wed/archive/2011/11/04/2236322.html