DELIMITER $$
CREATE PROCEDURE `explode`(IN input text,IN delim VARCHAR(10))
	BEGIN
		DECLARE foundPos tinyint UNSIGNED;
		DECLARE tmpTxt text;
		DECLARE delimLen tinyint UNSIGNED;
		DECLARE element text;
 
		DROP TEMPORARY TABLE IF EXISTS tmpValues;
		CREATE TEMPORARY TABLE tmpValues
		(
			`values` text NOT NULL DEFAULT ''
		);
 
		SET delimLen = length(delim);
		SET tmpTxt = input;
 
		SET foundPos = INSTR(tmpTxt,delim);
		WHILE foundPos <> 0 DO
			SET element = SUBSTRING(tmpTxt, 1, foundPos-1);
			SET tmpTxt = REPLACE(tmpTxt, CONCAT(element,delim), '');
 
			INSERT INTO tmpValues (`values`) VALUES (element);
 
			SET foundPos = INSTR(tmpTxt,delim);
		END WHILE;
 
		IF tmpTxt <> '' THEN
			INSERT INTO tmpValues (`values`) VALUES (tmpTxt);
		END IF;
 
		SELECT * FROM tmpValues;
	END $$
DELIMITER ;