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

1 vote275 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
2 votes282 views2 answers
Postgres select duplicate columns
SQL
8 votes269 views2 answers
Mysql query dates between two dates
SQL
0 vote283 views1 answer
Mysql where in keep order
SQL
2 votes275 views1 answer
Wait delay in sql server
SQL
0 vote261 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
10 votes339 views4 answers
Join multiple tables in sql
SQL
11 votes300 views3 answers
Sql line numbers
SQL
4 votes270 views1 answer
Sql query to make a existing column auto increment
SQL
12 votes291 views3 answers
Install sqlite driver ubuntu
SQL