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>
>
>
