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 vote208 views1 answer
Cartesian product sql
SQL
1 vote206 views2 answers
How to add amount between date in sql
SQL
1 vote192 views1 answer
Apex select list ORA-20999
SQL
0 vote306 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
6 votes210 views2 answers
Oracle compile trigger
SQL
2 votes176 views2 answers
Set database timezone mysql
SQL
0 vote173 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote165 views1 answer
Change default schema sql server
SQL
2 votes208 views3 answers
Current setting postgres timezone
SQL
0 vote182 views1 answer
Compare if is null sql
SQL