CASE in ORDER BY

Question

CASE in ORDER BY

Accepted Answer

CASE in ORDER BY maps text priority values to sort numbers, enabling custom sort orders that don't follow alphabetical or insertion order. high -> 1 (first), medium -> 2, low -> 3 (last). Result: Beta (high), Gamma (medium), Alpha (low). This technique is useful for any enum-like column where the natural order differs from alphabetical.