Change order of columns

[phouchin]

Hi, is there a way you can change the order of the columns in the database (I am using mysql)?

Thanks Peter

[alanl]

There's no real need. Just SELECT the_columns,in_the,order,you,want FROM yourtable

Cheers,
Alan

[Anon]

I need to change the order so that i can import data more easily in the database