blackwater dev, 28.07.2009 15:12:
> 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?
You need to list all columns that you want explicitely.
Using SELECT * in a production application is considered bad practice anyway
Thomas