Sorting by a priority label, not alphabetically

Question

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.