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

2 votes194 views2 answers
Sql first character
SQL
0 vote212 views1 answer
Convert polygon to text in mysql
SQL
0 vote190 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote204 views1 answer
Drop all procedures sql server
SQL
1 vote200 views1 answer
Show all event schedular on mysql
SQL
4 votes186 views3 answers
Order by value mysql
SQL
2 votes218 views2 answers
Create temporary table in mysql
SQL
17 votes192 views4 answers
Sort by mysql
SQL
2 votes223 views1 answer
Sql OR
SQL
5 votes200 views2 answers
Oracle tables with column name
SQL