/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

1 vote332 views2 answers
Select into temp table
SQL
0 vote315 views1 answer
Mysql cast null to string
SQL
3 votes323 views1 answer
Select sequence oracle
SQL
1 vote298 views1 answer
Add sequence postgres
SQL
2 votes319 views2 answers
Sql first character
SQL
2 votes317 views1 answer
Select sid oracle
SQL
1 vote318 views1 answer
Oracle update with sequence
SQL
5 votes344 views4 answers
Traduction
SQL
0 vote324 views1 answer
Authentication in sql server
SQL
8 votes321 views2 answers
Safe update mode in mysql
SQL