SELECT WHERE help

[nca]

How do you write a mysql select query that will look for a string in multiple columns? Here is a logical (incorrect) example:

SELECT COL1, COL2, COL5, COL32 FROM TABLE WHERE ???? LIKE "%$string%"

I would want it to look at the selected columns only.

[router]

SELECT *
FROM COL1,COL2,COL3
WHERE a.COL1='%string%' OR a.COL2='%string%' OR a.COL3='%string%' ;

Does it work?
Good luck!
Router