Mysql order by on condition

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

0 vote173 views1 answer
Create table as select sql server error
SQL
0 vote132 views1 answer
Change permission to database mysql
SQL
2 votes135 views1 answer
Cast string to datetime mysql
SQL
6 votes151 views1 answer
Allsource oracle
SQL
0 vote142 views1 answer
Rename constraint postgresql
SQL
3 votes182 views2 answers
Oracle sql first day of month
SQL
3 votes153 views2 answers
Search text in all sql server stored procedure
SQL
1 vote141 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote202 views1 answer
How to add auto increment primary key
SQL
0 vote125 views2 answers
Postgresql create role
SQL