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 votes236 views2 answers
Run mysql command from bash
SQL
3 votes244 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote241 views1 answer
Sql pivot table
SQL
2 votes230 views1 answer
Change primary key sql
SQL
19 votes195 views1 answer
Sqrt(-1)
SQL
4 votes182 views3 answers
Create table if not exists postgresql
SQL
1 vote234 views3 answers
What is union in sql
SQL
5 votes213 views1 answer
Oracle asynchronous procedure
SQL
3 votes231 views1 answer
Créer une table sql
SQL
1 vote248 views1 answer
Update from table tsql
SQL