select specified fields then the remainder of table

[dillpick6]

I was just wondering if there is a way to do something along the lines of:

SELECT field_1 , * FROM table

which would get field1, then the rest of the table, it is even ok if it got field1 twice. I just having it selecting * now, but I want field1 to be the first one seen. Any leads would be great. Thanks to all!

 

[swampBoogie]

There is o short cuts for this. You need to specify the columns explicitly if you want them in a different order as compared to the order in the table definition.