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

6 votes239 views4 answers
Mysql group by date
SQL
3 votes305 views1 answer
Oracle cannot access v$session
SQL
0 vote219 views1 answer
Sql server isnull function nor working count
SQL
0 vote200 views1 answer
Postgresql parse json array
SQL
5 votes231 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote208 views1 answer
Search db for table name
SQL
5 votes231 views3 answers
Postgres show databases
SQL
0 vote213 views1 answer
Oracle step procedure
SQL
14 votes229 views2 answers
Install mysqldump
SQL
4 votes204 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL