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.
SELECT * FROM foo ORDER BY FIELD(column, 'Z', 'B', 'C')