CONCAT all columns

CONCAT all columns

am 10.02.2006 20:25:36 von Tim Milstead

I want to produce a query that does something like this:

SELECT MD5(CONCAT(*)) FROM table WHERE 1

* is all the columns.
I don't want to have to type in every column name, but have MySQL do it.

Any ideas?

Thanks,

Tim