mysql 分割字符串

1、返回分割结果的个数

DELIMITER $$ 

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 

    # 计算传入字符串的总length 

    return 1+(length(f_string) - length(replace(f_string,f_delimiter,''))); 

END$$ 

DELIMITER; 

root @ ip地址

2、返回分割返回的字符

DELIMITER $$ 

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;  

 

call splitString("apple,banana,orange,pears,grape",","); 

select * from tmp_split;