MySQL～ IN , FIND_IN_SET , LIKE

SELECT * FROM test where area IN (1, 2, 3);

SELECT * FROM test where FIND_IN_SET('1', area);

SELECT * FROM test where area LIKE '%,1,%';

LIKE 是广泛的模糊匹配，字符串中没有分隔符
Find_IN_SET 是精确匹配，字段值以英文”,”分隔
Find_IN_SET 查询的结果要小于 LIKE 查询的结果。