MySQL : Order by 2 fields
Suppose I have a list of products, and each has a price. I wish to show the most expensive product, and if 2 products or more tie, then I wish to order by their name. Doing this doesn't seem to produce the results I want:

    ORDER BY cost DESC, product_name

What is the syntax which I am looking for?
MySQL : Order by 2 fields
===

Suppose I have a list of products, and each has a price. I wish to show the most expensive product, and if 2 products or more tie, then I wish to order by their name. Doing this doesn't seem to produce the results I want:

    ORDER BY cost DESC, product_name

What is the syntax which I am looking for?