Condition in orderby mysql

SELECT orders.status, orders.created_at
FROM `orders`
ORDER BY
  status='new' DESC,
  status='processing' DESC,
  CASE WHEN status IN ('new', 'processing') THEN created_at END ASC,
  CASE WHEN status NOT IN ('new', 'processing') THEN created_at END DESC

-1

Similar codes

5 votes229 views1 answer
AND OR NOT operators sql
SQL
0 vote203 views1 answer
Mysql max number not returning correct value
SQL
1 vote197 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
13 votes257 views6 answers
Mysql remove duplicates
SQL
1 vote202 views2 answers
Mysql join two tables
SQL
0 vote219 views1 answer
Sql server count all tables rows
SQL
14 votes207 views4 answers
Sql compiler
SQL
5 votes254 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote190 views1 answer
Mysql cdn link
SQL
0 vote248 views1 answer
Oracle sql date winter time
SQL