Searching all fields in a row

[Matt_Parsons]

I have a table with about 15 columns.
I want to be able to search each field in the row for the specified search term, before moving on to the next row. Is this possible and how.
I cant see how a select statement could do this.
Thanks for any help
Matt

[jeremuck]

SELECT * FROM table
WHERE col1= $term
OR col2 = $term
OR col3 = $term
OR col4 = $term
OR col5 = $term
OR col6 = $term
OR col7 = $term
OR col8 = $term
OR col9 = $term
OR col10 = $term
OR col11 = $term
OR col12 = $term
OR col13 = $term
OR col14 = $term
OR col15 = $term

If you only want 1, then add LIMIT 1.

This searches every column for the search term.