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 vote190 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote191 views2 answers
Cascade syntax in sql
SQL
0 vote218 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote212 views1 answer
Create database like
SQL
0 vote202 views1 answer
Original Query
SQL
0 vote205 views1 answer
Postgresql create user roles
SQL
0 vote203 views1 answer
Test connection to sql server
SQL
0 vote257 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote222 views2 answers
Mysql dump structure only
SQL
0 vote200 views1 answer
Sql select merge multiple values
SQL