6/30/2006
Statistics With MySQL
Need a quick count of repeated occurences of matching rows for statistical analysis?
SELECT search_query, count( search_query ) AS total
FROM search_log
GROUP BY search_query
ORDER BY total DESC
FROM search_log
GROUP BY search_query
ORDER BY total DESC
Popularity: 20%
