mysql find_in_set逗号隔开字符串查询包含某个值或某些值中某值

查询包含某值:

SELECT * from demo where FIND_IN_SET('3',type);

查询type包含 5或7或9

SELECT * FROM demo where CONCAT (',' ,type, ',') REGEXP ',(5|7|9),' ;