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