Then I think you want SELECT url, COUNT(DISTINCT ip_address) FROM tablename GROUP BY url;
> -----Original Message----- > From: John Kelly [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 21, 2003 3:45 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Need help constructing query ... > > > ----- Original Message ----- > From: "Daniel Clark" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, October 21, 2003 2:33 PM > Subject: Re: Need help constructing query ... > > > : > Hi, I have a table full of logged urls and ip addresses. > The following > : > query returns all the urls and the number of requests. How would I > : > modify it to return unique requests based on distinct ip > addresses? > : > > : > select url, count(*) as pageviews from table group by url order by > : > pageviews desc > : > : How about: > : > : SELECT ip_address, url, count(*) > : FROM tablename > : GROUP BY ip_adress, url > : > Thanks but I could not get that to work. It does not appear > to count the number of page requests by distinct IPs anyway > does it? Don't you need something like a > count(distinct(ip_address)) somewhere in there? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]