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 vote201 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote298 views1 answer
Oracle current sequence value
SQL
0 vote193 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote270 views1 answer
Oracle transaction rollback not working
SQL
0 vote183 views1 answer
Sql change date format
SQL
14 votes219 views2 answers
Sql cast
SQL
0 vote184 views1 answer
How to set all the min and sec data to zero in sql server
SQL
3 votes173 views1 answer
Start mysql server linux terminal
SQL
0 vote186 views1 answer
Sql change default collation to utf8
SQL
0 vote191 views1 answer
Recover deleted data from mysql database
SQL