Sorting Enum's 1

[skiflyer]

Is there a way to easily sort Enum's in the SQL query by the data rather than their position in the enumeration array?

i.e. I have a field called priority, it holds the values
1-10, A-D, Must, High, Medium, Low, Very Low, ''

(The last being blank string)

It sorts by the order I put them into the enum, which is actually better in this particular case... but I'm curious, if I wanted to sort by the normal alphabetical method on this column, could I?

 

[sleipnir214]

There is information at the bottom of this page of the MySQL online manual which talks about using the CAST() operator to sort ENUMs lexically.

Want the best answers? Ask the best questions!

TANSTAAFL!!