MySQL – finding most searched for term

To find the most searched for term in the search results of a MySQL table using phpMyAdmin:

SELECT term, COUNT(term) as count FROM table
GROUP BY term
ORDER BY count DESC

Leave a Reply

Your email address will not be published. Required fields are marked *