...

View Full Version : Order By



PureMisery
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.

guelphdad
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum