Get 10 Most Entered Entries

Question

Hi, I'm just wondering if it's possible to retrieve the the most entered entries from the mysql database

It's like this :

ID - Value

Id is auto increment, and value is the text that is being entered, i'd like to have it display the top 10 most entered terms, how could i do that?

Answer 1

SELECT value, COUNT(value) as times
FROM table 
GROUP BY value ORDER BY times DESC LIMIT 0,10;