DELIMITER $$
DROP function IF EXISTS `func_compare_split` $$
CREATE DEFINER=`root`@`%` FUNCTION `func_compare_split`
(f_string1 varchar(1000),f_string2 varchar(1000),f_delimiter varchar(5)) RETURNS bigint
BEGIN 
   # 拆分传入的字符串，返回拆分后的新字符串
    declare str1_length int default 0;
    declare str2_length int default 0;
    declare i,j int default 0;
    declare str1_each varchar(10) default '';
    declare str2_each varchar(10) default '';
    declare result int default 0;
     if(f_string1 = f_string2) then
         return 1;
    end if;
    set str1_length = 1+(length(f_string1) - length(replace(f_string1,f_delimiter,'')));
    set str2_length = 1+(length(f_string2) - length(replace(f_string2,f_delimiter,'')));
    if(str1_length != str2_length) then
       return 0;
    end if;
    loop1: while (i<str1_length) do
        set i = i + 1;
        set j = 1;
        set result = 0;
        set str1_each = reverse(substring_index(reverse(substring_index(f_string1,f_delimiter,i)),f_delimiter,1));
        while (j<=str2_length) do
              set str2_each = reverse(substring_index(reverse(substring_index(f_string2,f_delimiter,j)),f_delimiter,1));
                if(str1_each = str2_each) then
                      set result = 1;
                        iterate loop1;
                end if;
                set j = j + 1;
        end while;
        if(result = 0) then
             leave loop1;
        end if;
  end while loop1;
    return result;
END$$
DELIMITER;