[RESOLVED] ORDER BY = "ok" then "good" then "great" then "excellant"

[hatching]

I have a column that has a description rating of: ok, good, great, excellant.

How would I use the mysql_query to sort it by that order instead of using DESC/ASC to sort the first letter?

[dagon]

save your self some pain and space allocate them to 1 2 3 4, then just rewrite 1 to ok on the output or use a join.

or if you must

ORDER BY FIELD(rating,'ok','good','great','excellant')

[Weedpacket]

dagon's first suggestions would, for example, make it easier to change the column data to use the correct spelling of "excellent"....