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 votes130 views3 answers
Order by postgres
SQL
7 votes97 views6 answers
Group_concat in mysql
SQL
0 vote65 views1 answer
Import sql file in mysql linux
SQL
0 vote124 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote128 views3 answers
Constraint sql
SQL
13 votes106 views3 answers
Sql online code
SQL
3 votes126 views3 answers
List columns in table postgres
SQL
0 vote106 views1 answer
Psotgres multiple values
SQL
-1 vote116 views1 answer
How to Activate the database
SQL
0 vote96 views1 answer
Complete date is 1 year or not sql server
SQL