From: Ed Carp
Date: March 20 1999 6:37pm
Subject: Re: Help with query, plz
List-Archive: http://lists.mysql.com/mysql/692
Message-Id: <006a01be7300$cc0f46a0$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>> COUNT(DISTINCT(...)) doesn't work in MySQL (yet).  Try this:
>> 
>> SELECT COUNT(*) FROM table GROUP BY ip;
>
>It tells me how many times each IP is in the table, but that's not what I
>need. I need the count of >different< IPs.


How about

SELECT ip INTO temp_table
FROM table
GROUP BY ip
HAVING (((Count(ip))<>1));

SELECT Count(*) FROM temp_table;

The temp table will only have the non-unique ip's.