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

2 votes225 views1 answer
Docker run postgres locally
SQL
11 votes222 views2 answers
Having clause
SQL
1 vote238 views1 answer
Duplicating a MySQL table with all the data Command
SQL
3 votes216 views1 answer
Pl sql check if variable is empty
SQL
2 votes243 views1 answer
When matched in sql server
SQL
1 vote243 views3 answers
What is union in sql
SQL
4 votes219 views1 answer
Oracle show errors compilation
SQL
2 votes246 views3 answers
Sql function
SQL
0 vote239 views1 answer
Update database collation in postgresql
SQL
2 votes239 views1 answer
Drop all database tables oracle sql developer
SQL