DELIMITER $$
USE `mydb`$$
DROP FUNCTION IF EXISTS `get_content_before_last_separator`$$
CREATE DEFINER=`root`@`%` FUNCTION `get_content_before_last_separator`(charStr VARCHAR(200),separatorStr VARCHAR(200)) RETURNS VARCHAR(64) CHARSET utf8
BEGIN
DECLARE resultStr VARCHAR(200);
SELECT SUBSTRING_INDEX(charStr,separatorStr,LENGTH(charStr)-LENGTH(REPLACE(charStr,separatorStr,''))) INTO resultStr FROM DUAL;
RETURN resultStr;
END$$
DELIMITER ;