selecting all columns but one

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!