Hi there,

I am working on a watch-reseller's site. Each product has a grade 'Unworn', 'Excellent', 'Good', 'Average'.

I need to order by Grade, but obviously MySQL will order alphabetically. So 'Unworn', 'Good', 'Excellent', 'Average', or vise versa. Not good. The obvious solution would be to have a `grades` table and then order the results by grade id, with an INNER JOIN... but before I change my database design, I was wondering if anyone could suggesta more elegant solution.

Many thanks,
Mike