/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 vote289 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
3 votes309 views2 answers
Enter mysql command line
SQL
0 vote332 views1 answer
Postgres meta command to show all rows in table
SQL
5 votes301 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote295 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
1 vote284 views1 answer
How to delete record sql delphi
SQL
1 vote295 views1 answer
Sql exclude duplicates and find even id
SQL
1 vote254 views1 answer
Unique vs distinct sql
SQL
0 vote326 views1 answer
Insert ip address in mysql
SQL
24 votes314 views4 answers
Mysql datetime
SQL