SQL where ANY column is equal to

Question

Is it possible in MySQL to select all rows in which the ANY column contains the specified value?

I am trying to write a universal search function that can work without any information about the table schema.

Answer 1

Use SHOW COLUMNS to get a list of columns in a table, and then dynamically build the query from the results.