SELECT ...
FROM yourtable
WHERE 'val' IN (field1, field2, field3, field4, ...)

如果您正在寻找精确的全场匹配.如果您正在寻找子字符串匹配，则必须走很长一段路:

if you're looking for exact full-field matches. If you're looking for substring matches, you'll have to go about it the long way:

WHERE field1 LIKE '%val%' or field2 LIKE '%val%' etc....