以逗号分隔的字符串是否交集
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 ;