View Full Version : Order By

09-04-2006, 07:53 PM
I have a column called `type`, the value for each row is one of 12 possibilities. Is there a way to have the query results sorted according to the type besides the normal alphabetical sort?

Ex, have the results shown in this order: boots, body, orbs, augments.

09-04-2006, 08:54 PM
order by field(fieldname,'boots', 'body', 'orbs', 'augments')
note you can only use this in mysql it isn't standard sql.