mysql自定义循环函数

最新推荐文章于 2024-07-22 03:54:21 发布

weixin_30865427

最新推荐文章于 2024-07-22 03:54:21 发布

阅读量3k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/alexwu59/p/5066127.html

FUNCTION deyes.f_getSplitStringByIndex1_8(stringIn text,
delimiter varchar(10),
indexIn int)
RETURNS text CHARSET utf8
COMMENT 'by wushuai'
BEGIN
DECLARE result varchar(255) DEFAULT '';
SET result = REVERSE(SUBSTRING_INDEX(REVERSE(SUBSTRING_INDEX(stringIn, delimiter, indexIn)), delimiter, 1));
RETURN result;
END

FUNCTION deyes.f_getSplitStringTotal1_8(stringIn text,
delimiter varchar(10))
RETURNS int(11)
COMMENT 'by wushuai'
BEGIN
IF stringIn IS NOT NULL AND LENGTH(stringIn) <> 0 THEN
RETURN 1 + (LENGTH(stringIn) - LENGTH(REPLACE(stringIn, delimiter, '')));
ELSE
RETURN 0;
END IF;
END

转载于:https://www.cnblogs.com/alexwu59/p/5066127.html