List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:February 24 2000 3:14pm
Subject:Re: Count of distinct?
View as plain text  
perhaps:

SELECT IP, count(IP) FROM table GROUP BY IP;


----- Original Message -----
From: "Bob German" <stbob@stripped>
To: "MySQL mailing list" <mysql@stripped>
Sent: Thursday, February 24, 2000 9:48 AM
Subject: Count of distinct?


>
> In a table of accesses (imported logfile) with a field called IP, how can
I
> get a count of distinct IP?
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread28854@stripped
>
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-GraemeD=uu.net@stripped>
>
>

Thread
Count of distinct?Bob German24 Feb
  • Re: Count of distinct?Graeme B. Davis24 Feb
  • Re: Count of distinct?sinisa24 Feb