MySQL SPLIT_STRING function

split_string

-- use this as a stored function
CREATE FUNCTION SPLIT_STRING(str VARCHAR(255), delim VARCHAR(12), pos INT)
RETURNS VARCHAR(255)
DETERMINISTIC
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(str, delim, pos),
       LENGTH(SUBSTRING_INDEX(str, delim, pos-1)) + 1),
       delim, '');

-- use this as a stored function 

CREATE DEFINER=`root`@`localhost` FUNCTION `SPLIT_STRING`(
	`str` VARCHAR(255),
	`delim` VARCHAR(1),
	`pos` INT
)
RETURNS varchar(255) CHARSET utf8 COLLATE utf8_unicode_ci
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT 'pendant of PHP EXPLODE (Haysack, Needle, element_staring_with_1)'
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(str, delim, pos),
       LENGTH(SUBSTRING_INDEX(str, delim, pos-1)) + 1),
       delim, '')