方法一
SELECT * FROM tableName WHERE columnName LIKE '%1740 %'
OR columnName LIKE '%1938 %'
OR columnName LIKE '%1940 %';
方法二(FIND_IN_SET 是精准匹配,使用%无效)
SELECT * FROM tableName WHERE FIND_IN_SET(columnName, "1740,1938,1940");
方法三 (正则表达式)
SELECT * from tableName where columnName REGEXP '1740|1938|1940';