How to code an SQL query with ORDER BY as a variable?

Databases
6 
ORDER
    BY CASE WHEN :menu_order = 1 THEN item 
            WHEN :menu_order = 2 THEN -1 * item 
            WHEN :menu_order = 3 THEN profit 
                                 ELSE -1 * profit 
        END  ASC