SET @string:='one,tow,three,four,five,six,seven,eight,nine,ten';
SET @row:=0;
SET @length:=LENGTH(@string)-LENGTH(REPLACE(@string,',',''))+1;
SET @from_clause:=CONCAT('SELECT 1 ',REPEAT(' UNION ALL SELECT 1 ',9));

SET @sql:=CONCAT("
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@string,',',@row:=@row+1),',',-1) AS numbers 
FROM (",@from_clause,")a JOIN (",@from_clause," )b LIMIT ",@length);

PREPARE st FROM @sql;
EXECUTE st;

numbers	
----------
one	
tow	
three	
four	
five	
six	
seven	
eight	
nine	
ten