SQL sorting - Alpha > Numbers > Symbols

SQL sorting - Alpha > Numbers > Symbols.sql

        SELECT id, title
        FROM table
        ORDER BY
        CASE
        WHEN title regexp '^[a-zA-Z]+' THEN
        1
        WHEN title regexp '^[0-9]+' THEN
        2
        WHEN title regexp '^[^\w]+' THEN
        3
        WHEN title = ''
        OR
        title IS NULL THEN
        4
        ELSE 5
        END,
        title * 1 ASC,
        title