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]

Reply via email to