I was wondering how to not show a certain column with SQL.

I know that to show certain columns you can list them like so:
SELECT column1, column2, column3 FROM tablename1

But what if I have 100 columns in my database and I want to show 99 of them? Do I have to list all 99 of them out? Is there an easier way that might look something like this?

SELECT NOT column100 FROM tablename1

not that i know of, i dont think this can be done with a 'NOT'

www.crmpicco.co.uk