here’s a little query that’ll return the 10 most common values for any particular field in a MySQL table.

SELECT <column>, COUNT(<column>) AS popularity
FROM <table>
GROUP BY <column>
ORDER BY popularity DESC limit 10;