create function FIND_SET_IN_SET(IN input TEXT, IN STRLIST TEXT) RETURNS INT
BEGIN

Declare delimiter VARCHAR(10) default ',';
DECLARE cur_position INT DEFAULT 1 ;
DECLARE remainder TEXT;
DECLARE cur_string VARCHAR(1000);
DECLARE delimiter_length TINYINT UNSIGNED;
DECLARE cur1 CURSOR FOR select value from SplitValues;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
DECLARE val varchar(1000);
DECLARE retval INT default 0;


DROP TEMPORARY TABLE IF EXISTS SplitValues;
CREATE TEMPORARY TABLE SplitValues (
value VARCHAR(1000) NOT NULL PRIMARY KEY
) ENGINE=MEMORY;
SET remainder = input;
SET delimiter_length = CHAR_LENGTH(delimiter);
WHILE CHAR_LENGTH(remainder) > 0 AND cur_position > 0 DO
SET cur_position = INSTR(remainder, delimiter);
IF cur_position = 0 THEN
SET cur_string = remainder;
ELSE
SET cur_string = LEFT(remainder, cur_position - 1);
END IF;
IF TRIM(cur_string) != '' THEN
INSERT INTO SplitValues VALUES (cur_string);
END IF;
SET remainder = SUBSTRING(remainder, cur_position + delimiter_length);
END WHILE;

OPEN cur1;
REPEAT
    FETCH cur1 INTO val;
    set retval = FIND_IN_SET(val, STRLIST);
    IF retval != 0 THEN
        set done = 1;
    END IF;
UNTIL done END REPEAT;
CLOSE cur1;

DROP TEMPORARY TABLE IF EXISTS SplitValues;

return retval;
END;