I changed it around a bit to count distict requests and dates and group by ip. This did the trick!
On 6/8/07, Ally Messi <[EMAIL PROTECTED]> wrote:
Can someone please help me with the following: code so far SELECT DISTINCT ip, COUNT(DISTINCT round_to_nearest_five_minutes(date)) as url_hit_count, request from logs_empty GROUP BY substring_index(request, '/', 3) ; I would like to add on to the the code an additional column that adds up the url_hit_count where the ip column value's are the same. How do I do this? Thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
