56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE DEFINER=`bmmcoo`@`%` FUNCTION `func_splitString`(string_complete varchar(8000),delimiter varchar(8000),string_location int) RETURNS varchar(8000) CHARSET utf8
BEGIN
DECLARE string_splitted varchar(8000) default "";
set string_splitted = reverse(substring_index(reverse(substring_index(string_complete,delimiter,string_location)),delimiter,1));
RETURN string_splitted;
END
select func_splitString("11,12,13,21,22,31",",",3);
//结果是"13"
set @Str='11,12,13,21,22,31';
select LENGTH(@Str)-length(replace(@Str,',',''))+1 as 个数;
/*
个数
6
*/
CREATE DEFINER=`bmmcoo`@`%` FUNCTION `func_splitnum`(string_complete varchar(8000),delimiter varchar(8000)) RETURNS int(11)
BEGIN
DECLARE string_splitnum int;
set string_splitnum = (length(string_complete)-length(replace(string_complete,delimiter,''))+length(delimiter))/length(delimiter);
RETURN string_splitnum;
END