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