摘要： 恢复内容开始 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 结果 阅读全文