Posted by timvw on December 9, 2004
As a follow up to Custom Ordering I discovered the nice Field function in MySQL. after it was mentionned on my favorite PHP Forum by Weirdan. It allows one to order a column on a custom order relation.
ORDER BY FIELD(column, 'Z', 'B', 'C')