Averaging all the columns in a table at once

[anthony522]

Is there a way to find out the average of all the columns in a table without naming each individually in the SELECT statement?

I the following with no luck:

SELECT AVG(*)
FROM rate
WHERE q1a = '1'

Any ideas?

[LordShryku]

No

[anthony522]

Darn, this is going to take a while.

Thanks for the quick response.