Sort Select Results by Arbitrary Values

SELECT ColumnOne, ColumnTwo, ColumnThree FROM Table ORDER BY CASE ColumnTwo WHEN ‘miny’ 1 WHEN ‘meeny’ 2 WHEN ‘eeny’ 3 WHEN ‘moe’ 4 END, ColumnThree