Re: Help with query, plz

[Ed Carp]

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