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

5 votes293 views1 answer
Mysql count newlines in field
SQL
0 vote301 views1 answer
Ms sql print more than 1 variable
SQL
6 votes285 views1 answer
Phpmyadmin password root
SQL
3 votes280 views4 answers
Mysql decimal
SQL
1 vote286 views1 answer
Float precision in psql
SQL
1 vote324 views1 answer
How to see logical reads in sql server
SQL
0 vote288 views1 answer
Renombrar tabla mysql
SQL
0 vote320 views1 answer
Sqlite trim
SQL
4 votes365 views3 answers
Mysql get column names from table
SQL
0 vote271 views1 answer
Raiserror nowait sql server
SQL