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 votes277 views1 answer
Mysql insert on dupèlicate
SQL
0 vote254 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
-1 vote258 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote262 views2 answers
Postgres default user
SQL
0 vote243 views1 answer
Django how to get query result count
SQL
0 vote240 views1 answer
Mysql local password denied
SQL
0 vote275 views1 answer
How to remove quotes from a string in ssis load file
SQL
47 votes313 views6 answers
Add column mysql
SQL
0 vote261 views1 answer
Create database store
SQL
0 vote258 views1 answer
Mysql preg replace
SQL