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