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 vote187 views1 answer
Cahnge column name apex oracle
SQL
1 vote128 views1 answer
How to delete data from sql database in android
SQL
0 vote134 views1 answer
Sql server whoami
SQL
0 vote145 views2 answers
Import .sql into postgres db command
SQL
0 vote91 views1 answer
Psql not found windows
SQL
0 vote159 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
4 votes135 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
31 votes152 views3 answers
Sql count
SQL
1 vote152 views1 answer
Convert to hexadecimal sql
SQL
0 vote155 views2 answers
Select last 30 days sql
SQL