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

0 vote212 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote185 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote169 views1 answer
Create function syntax sql server
SQL
16 votes198 views3 answers
Jwt secret key generator laravel
SQL
4 votes193 views3 answers
Postgres set default value
SQL
0 vote192 views1 answer
Is not sql
SQL
1 vote184 views1 answer
Mysql add fields
SQL
0 vote173 views1 answer
Mysql concat and use as where column
SQL
0 vote194 views1 answer
Sql server set complex constraints
SQL
1 vote175 views1 answer
Oracle create program if no exists
SQL