Page 1 of 1

mysql - order the fields should be displayed

Posted: Sat Jul 31, 2004 2:11 pm
by nigma
say I have a table with three fields: field1, field2, field3

I want to perform a query and want the results to be ordered by field2, field3, field1

I remember seeing a tutorial on how to do this a while ago, but can't find it now, anyone know how to do this?

Thanks

Posted: Sat Jul 31, 2004 2:14 pm
by feyd

Code: Select all

... ORDER BY field2, field3, field1
:?: :?

Posted: Sat Jul 31, 2004 2:20 pm
by nigma
haha, don't laugh! thanks