------------恢复内容开始------------
eg:有个value表 val列如下:
SELECT * from (SELECT id,SUBSTRING_INDEX(val,'|',1) as va1,
SUBSTRING_INDEX(val,'|',-1) as va2 from `value` )a where id=1
结果:
SELECT * from (SELECT id,SUBSTRING_INDEX(val,'|',1) as t1,
SUBSTRING_INDEX(SUBSTRING_INDEX(val,'|',2),'|',-1) as t2,
SUBSTRING_INDEX(SUBSTRING_INDEX(val,'|',3),'|',-1) as t3,
SUBSTRING_INDEX(val,'|',-1) as t4 from `value` )a where id=2;