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

3 votes182 views2 answers
Order by postgresql
SQL
2 votes170 views1 answer
Set column to not null mysql
SQL
1 vote202 views2 answers
Drop table with constraints
SQL
0 vote187 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote192 views1 answer
Renommer base sql
SQL
14 votes199 views3 answers
SQL trim
SQL
0 vote181 views1 answer
Como hacer una consulta en sql
SQL
4 votes227 views3 answers
Postgres drop all tables
SQL
53 votes540 views6 answers
Sql server alter column
SQL
2 votes176 views4 answers
Mysql get all tables row count
SQL