DROP FUNCTION IF EXISTS SPLIT_STRING;

DELIMITER //

CREATE FUNCTION SPLIT_STRING(str VARCHAR(255), delim VARCHAR(12), pos INT)
BEGIN
RETURNS VARCHAR(255)
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(str, delim, pos),
	   LENGTH(SUBSTRING_INDEX(str, delim, pos-1)) + 1),
	   delim, '');
END//

GRANT EXECUTE ON PROCEDURE wp_fishdev.SPLIT_STRING TO 'root'@'localhost';
GRANT EXECUTE ON PROCEDURE wp_fishdev.SPLIT_STRING TO 'root'@'127.0.0.1';

DELIMITER ;