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

4 votes160 views1 answer
Mysql copy table with new name
SQL
0 vote173 views2 answers
How to use aggregate functions in sql
SQL
0 vote219 views1 answer
Postgressql uuid
SQL
1 vote177 views1 answer
Sql count value greater than
SQL
0 vote247 views1 answer
Run docker container with database as rds metabase
SQL
0 vote183 views1 answer
Psql generate id in existing database
SQL
0 vote156 views1 answer
How to get data between a last week in mysql
SQL
0 vote173 views1 answer
Sql max min
SQL
0 vote158 views1 answer
Sql contains numeric characters
SQL
3 votes187 views1 answer
Where id is in list sql
SQL