mysql同时满足升序和降序_MYSQL通过升序和降序排序

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?

解决方案

You can do that in this way:

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