mysql 函数
DELIMITER $$ USE `teacherplatfrom`$$ DROP FUNCTION
IF EXISTS `func_split`$$ CREATE DEFINER=`payu`@`%` FUNCTION
`func_split`(f_string VARCHAR(1000),f_delimiter VARCHAR(5),i INT) RETURNS
VARCHAR(255) CHARSET utf8 BEGIN DECLARE result VARCHAR(255) DEFAULT ‘‘; # 获取前 i
个字符串反转再获取第一个字符串再反转 SET result =
REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(f_string,f_delimiter,i)),f_delimiter,1));
RETURN result; END$$ DELIMITER ; DELIMITER $$ USE `teacherplatfrom`$$ DROP
FUNCTION IF EXISTS `func_split_TotalLength`$$ CREATE DEFINER=`payu`@`%` FUNCTION
`func_split_TotalLength`(f_string VARCHAR(1000),f_delimiter VARCHAR(5)) RETURNS
INT(11) BEGIN RETURN 1+(LENGTH(f_string) -
LENGTH(REPLACE(f_string,f_delimiter,‘‘))); END$$ DELIMITER ;