/SQL/Mysql order by where condition sub query

Mysql order by where condition sub query

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

Similar codes

5 votes149 views1 answer
Mysql last day of next month
SQL
0 vote130 views1 answer
Postrgres trunc
SQL
2 votes144 views2 answers
Create temporary table in mysql
SQL
-1 vote127 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote147 views1 answer
Mysql group by derived column
SQL
0 vote135 views1 answer
Get week day name sql server
SQL
0 vote144 views1 answer
Query params sql insert python f string
SQL
0 vote235 views1 answer
Mysql select field if condition
SQL
-1 vote145 views4 answers
Restart mysql server ubuntu
SQL
0 vote126 views1 answer
Install mysql 8 linux
SQL