selecting all columns but one

[blackwater dev <blackwaterdev@xxxxxxxxx>]

I have a table with a lot of columns.  One of the columns I want to alias so have a query of:

select *, column as newname from mytable.

The problem is I now have column and newname in the results.  I don't want to select column by column.  How can I do a select * but omit one?

Thanks!