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

0 vote334 views1 answer
Oracle last connection
SQL
0 vote368 views1 answer
Change magento database url usimg musql
SQL
1 vote366 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
2 votes401 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote342 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote358 views1 answer
How to check the mysql version mac
SQL
92 votes654 views6 answers
Substring
SQL
0 vote345 views1 answer
Disableforiegn key check
SQL
0 vote355 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote387 views1 answer
Postegresql update to null
SQL