select only columns which do not contain zero

[mr_newbie]

i have a table with around 20 columns of data.

How do i do a query to select only the columns which do not contain 0 ?

Thanks in advance!

[Yelgnidroc]

SELECT * FROM tablename WHERE columnname != 0

[mr_newbie]

But SELECT * will show all columns.

Maybe this will be clearer:

I want to do a query to find columns which do not contain 0's
Only these columns will appear in the results, the columns which contain all zeros will not be displayed.