# 拆分传入的字符串,返回拆分后的新字符串
DELIMITER $$
USE `book`$$
DROP FUNCTION IF EXISTS `func_split`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `func_split`(f_string VARCHAR(1000),f_delimiter VARCHAR(5),f_order INT) RETURNS VARCHAR(255) CHARSET utf8
BEGIN
DECLARE result VARCHAR(255) DEFAULT '';
SET result = REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(f_string,f_delimiter,f_order)),f_delimiter,1));
RETURN result;
END$$
DELIMITER ;
# 拆分传入的字符串,返回拆分后的新字符串
DELIMITER $$
USE `book`$$
DROP FUNCTION IF EXISTS `func_split_TotalLength`$$
CREATE DEFINER=`root`@`localhost` 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 ;
-- 把拆分的字符串拼接成查询语句
DELIMITER $$DROP PROCEDURE IF EXISTS `splitStringTest` $$
CREATE PROCEDURE `splitStringTest` (IN f_string VARCHAR(1000),IN f_delimiter VARCHAR(5))
BEGIN
# 拆分结果
DECLARE cnt INT DEFAULT 0;
DECLARE i INT DEFAULT 0;
SET cnt = func_split_TotalLength(f_string,f_delimiter);
WHILE i < cnt DO
SET i = i + 1;
SET rId = func_split(f_string,f_delimiter,i);
#获取rld可进行增删改成
END WHILE;END$$
DELIMITER;