#创建FUNCTION
DELIMITER ;
CREATE FUNCTION `is_mixed`(str1 TEXT, str2 TEXT) RETURNS TINYINT
BEGIN
DECLARE ismixed TINYINT DEFAULT 0;
set ismixed:=(select concat(str1, ‘,‘) regexp concat(replace(str2,‘,‘,‘,|‘), ‘,‘));
RETURN ismixed;
END;
DELIMITER ;
mysql 判断两个字符串是否存在包含关系-------(1,2,3)与(2,3)
原文:http://www.cnblogs.com/save-shengfei/p/7246474.html