以逗号分隔的字符串是否交集

delimiter $$

use `tzjob`$$

drop function if exists `is_mixed`$$

create definer=`root`@`localhost` function `is_mixed`(str1 text,str2 text) returns tinyint(4)
begin
	declare ismixed tinyint default 0;
	set ismixed:=(select concat('#',replace(str1,',','#|#'),'#') regexp concat('#',replace(str2,',','#|#'),'#'));
	return ismixed;
end$$

delimiter ;