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 vote358 views1 answer
Generate sql from specific migration ef core
SQL
0 vote351 views1 answer
Mysql workbench format date
SQL
38 votes310 views4 answers
Count sql
SQL
4 votes337 views1 answer
Sql select limit range
SQL
0 vote363 views3 answers
How to find all role in mysql
SQL
2 votes298 views1 answer
Merge two columns in sql oracle
SQL
0 vote297 views1 answer
How to install mysql without admin rights
SQL
0 vote317 views1 answer
Show the colums of table sql
SQL
0 vote317 views1 answer
Sql alter table add column if exists
SQL
0 vote317 views1 answer
Second Step in installing SQL workbench
SQL