二、拆分成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"
