Thanks, Shawn. I didn't think count would just limit to the items being grouped - very handy =)
-Ed > SELECT URL, count(1) as popularity > FROM yourtablename > GROUP BY URL > ORDER BY popularity DESC > LIMIT 50; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]