Look up Two Fields in One Query

[D_tunisia]

Is it possible to look up a value in two fields of the same table at once?

I want to be able to look in two fields and if X appears in either field I want to display that in my query result.

Hope I made it clear enough!

[Pig]

SELECT * FROM table WHERE col1 = $x OR col2 = $x