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
GROUP BY term
ORDER BY count DESC
To find the most searched for term in the search results of a MySQL table using phpMyAdmin: