How to Sort a MySQL Table by Multiple Columns (Rating and Date)?

Sorting MySQL Tables by Multiple Columns

Question:

How can I order a MySQL table by multiple columns, specifically by highest ratings first and then by most recent date?

Answer:

To sort a MySQL table by two columns, use the ORDER BY clause with multiple columns. By default, sorting is ascending, but you can add the DESC keyword to both columns to sort in descending order:

ORDER BY article_rating DESC, article_time DESC

This will sort the table by the article_rating column in descending order (highest ratings first) and then by the article_time column in descending order (most recent date first).

Example:

Consider the following table:

article_rating	article	article_time
50	This article rocks	Feb 4, 2009
35	This article is pretty good	Feb 1, 2009
5	This Article isn't so hot	Jan 25, 2009

Using the ORDER BY clause with multiple columns:

SELECT * FROM articles ORDER BY article_rating DESC, article_time DESC

Will produce the following sorted output:

article_rating	article	article_time
50	This article rocks	Feb 4, 2009
35	This article is pretty good	Feb 1, 2009
5	This Article isn't so hot	Jan 25, 2009

The above is the detailed content of How to Sort a MySQL Table by Multiple Columns (Rating and Date)?. For more information, please follow other related articles on the PHP Chinese website!