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 vote325 views1 answer
Inserted row count tsql
SQL
0 vote384 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
1 vote344 views1 answer
Sql current timestamp
SQL
6 votes326 views2 answers
Database url postgres
SQL
0 vote314 views1 answer
Optimize sql query
SQL
0 vote327 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote368 views1 answer
Mysql default port
SQL
1 vote319 views1 answer
Mysql change root mysql_native_password
SQL
10 votes308 views1 answer
All_dependencies
SQL
0 vote337 views2 answers
Update information in a mysql column
SQL