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

2 votes150 views1 answer
Express api ith mysql data
SQL
0 vote135 views1 answer
Mysql get 2nd value in comma separated list
SQL
20 votes144 views2 answers
Mysql bigint max value
SQL
0 vote137 views1 answer
Call function in query sql server
SQL
0 vote140 views2 answers
How to update date in oracle
SQL
7 votes137 views1 answer
Sql server convert string to date
SQL
0 vote165 views1 answer
Leftjoin in sql
SQL
3 votes138 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote94 views1 answer
Update row in sqlite python
SQL
0 vote145 views1 answer
Mysql replication change database name
SQL