MYSQL order by both Ascending and Descending sorting

Question

I have a mysql table with products. The products have a category ID and a name. What I'd like to do is order by category id first descending order and then order by product name ascending order. ``` SELECT * FROM `products` ORDER BY `products`.`product_category_id`,`naam` DESC ``` What i'd like is ``` SELECT * FROM `products` ORDER BY `products`.`product_category_id`,`naam` DESC,ASC ``` but that unfortunately doesn't work. Is this even possible in mysql to define the sorting order of the second sorting column?

Accepted Answer

You can do that in this way:

```
ORDER BY `products`.`product_category_id` DESC ,`naam` ASC
```

Have a look at `ORDER BY` Optimization

MYSQL order by both Ascending and Descending sorting

Solution

Problem