日志类别:数据库
2019-06-21 11:25
create function GetSplit
(f_string text,f_delimiter varchar(50),f_order int)
returns varchar(255)
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