[RESOLVED] ORDER BY

[zzz]

If I have ENUM field with the following options:

'Y', 'N', 'X'

Can I arrange my results to show all = 'Y', THEN all = 'N' and then 'X' ?

[rsmith]

you can do an ORDER BY <column name> replace <column name> with the name of your ENUM column. But to get it into a specific order I'm not 100% sure. I had a simliar issue a long time ago but what I ended up doing was creating separate queries for each and then printing them in the order I wanted.

[Sxooter]

You can get custom ordering with a case statement:

order by
case when field='Y' then 1
when field='N' then 2
when field='X' then 3
end

[zzz]

Wow, I've never seen anything like this but it works great!