/SQL/Mysql order by where condition sub query

Mysql order by where condition sub query

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

Similar codes

0 vote203 views1 answer
Liquibase update row
SQL
4 votes155 views1 answer
Mysql ip address
SQL
4 votes150 views1 answer
Check database name postgresql
SQL
2 votes168 views1 answer
Use cases condition in sql query laravel
SQL
1 vote265 views1 answer
How to select department from table
SQL
0 vote185 views1 answer
Mysql bind-address default value
SQL
0 vote163 views1 answer
Sql server size of every table in a db
SQL
0 vote160 views1 answer
Turnicate in mysql
SQL
8 votes154 views1 answer
Oracle search source code
SQL
0 vote159 views1 answer
Mysql update from select on same table
SQL