mysql实现split

SELECT b.*,SUBSTRING_INDEX(SUBSTRING_INDEX(b.oldcode,‘|’,help_topic_id+1),‘|’,-1) AS num
FROM mysql.help_topic ,tmp_sopec b
WHERE help_topic_id < LENGTH(b.oldcode)-LENGTH(REPLACE(b.oldcode,‘|’,‘’))+1

tmp_sopec 换成任意表