Salut !

What I'm trying to do is to search for data in all the columns from a table. I'm using mySQL 5 and I'm making my query using the mySQL command line utility.

Let's say that I have a table with 10000 records and 25 columns and I'm searching for any null value anywhere in the table.

I've tried : SELECT * FROM mytable WHERE * IS NULL; but it's not working.

Do IO have to list all columns on by one to get this done or is there any solution to my problem ?

Thanks
-Martin