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

User · 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

User · Answer

I don t understand what the meaning of ordering with the same column ASC and DESC in the same ORDER BY  but this how you can do it  naam DESC  naam ASC like so   ORDER BY  product category id  DESC  naam  DESC   naam  ASC

[mysql] MYSQL order by both Ascending and Descending sorting

Examples related to mysql

Examples related to sql

Examples related to sorting