select * from (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('2001-11-11,2002-11-11,2003-11-11,2004-11-11',',',help_topic_id+1),',',-1) AS num
FROM mysql.help_topic
WHERE help_topic_id < LENGTH('2001-11-11,2002-11-11,2003-11-11,2004-11-11')-LENGTH(REPLACE('2001-11-11,2002-11-11,2003-11-11,2004-11-11',',',''))+1)a
效果:
求最大的时间
select max(cast(num as datetime)) lasttime from (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('2001-11-11,2002-11-11,2003-11-11,2004-11-11',',',help_topic_id+1),',',-1) AS num
FROM mysql.help_topic
WHERE help_topic_id < LENGTH('2001-11-11,2002-11-11,2003-11-11,2004-11-11')-LENGTH(REPLACE('2001-11-11,2002-11-11,2003-11-11,2004-11-11',',',''))+1)a