Order by with case statement

Question

I would like use CASE statement in ORDER BY clausule like this:

ORDER BY  
    CASE
        WHEN `Delivery`.`type` = 0 THEN `Delivery`.`quantity` ASC
        WHEN `Delivery`.`type` = 1 THEN `Delivery`.`quantity` DESC
    END

But I can use ASC/DESC keywords only after the END.

There is some solution for this?

Answer 1

You can use query like:

SELECT columns FROM tables WHERE condition 
ORDER BY  
CASE    
  WHEN `Delivery`.`type` = 0 THEN `Delivery`.`quantity` ASC,
  WHEN `Delivery`.`type` = 1 THEN `Delivery`.`quantity` DESC
END;

Answer 2

Using the following link for reference, I've put this together for your scenario.

MySQL conditional ORDER BY ASC/DESC for date column

ORDER BY 
      CASE WHEN `Delivery`.`type` = 0 THEN `Delivery`.`quantity` END ASC,
      CASE WHEN `Delivery`.`type` = 1 THEN `Delivery`.`quantity` END DESC;