sql - 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?

question from:https://stackoverflow.com/questions/13468781/mysql-order-by-both-ascending-and-descending-sorting

Answer 1

You can do that in this way:

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

Have a look at ORDER BY Optimization