coolispaul
asked on
How to retrieve fields in mysql in certain order
Hi
I have a database structure with fields in the database in this order:
ID
Name
Surname
Address
Town
How, do i retrieve using a select statment in say this order:
ID
Name
Town
Surname
Address
I have a database structure with fields in the database in this order:
ID
Name
Surname
Address
Town
How, do i retrieve using a select statment in say this order:
ID
Name
Town
Surname
Address
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FROM TableName;
Don't need to care about the column order in tables. Always feel free to change the order in query.