/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
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote296 views1 answer
Connexion mysql
SQL
1 vote272 views1 answer
SQLSTATE[HY000] [2002]
SQL
2 votes284 views1 answer
Apex date today add days
SQL
0 vote304 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
2 votes271 views1 answer
Mysql add boolean column
SQL
2 votes295 views2 answers
Change mysql password from command line
SQL
1 vote359 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote308 views1 answer
How to check which table has data in mysql
SQL
0 vote303 views1 answer
What is between keyword used for
SQL