SQL search over all columns in a table

[Hotkey]

Hi!

I've to search all columns of a table after a given text.
As the table has 34 columns i want to know if there is a sql statement which searches over all columns.
So that i dont have to use
SELECT id from tableA where columnA='test' OR columnB='test' [...] OR columnZ='test'

something like
SELECT id from tableA WHERE somewhereInSomeColum='test'

Thanks in advance!!!

[laserlight]

Why do you want to search all the columns of a table for a given text?

It sounds like the design of the database has a problem.

[Hotkey]

Its not my database and i have to search all columns cause i simply dont know where the pattern might be stored...
I know that this is not the way to design a database or a search, but i dont have an alternativ right now

[laserlight]

You could run a:
SHOW COLUMNS FROM tablename;

From the results of this query you obtain the names of the columns, after which you can dynamically construct your actual SQL statement.