From: Thimble Smith
Date: March 20 1999 6:25pm
Subject: Re: Help with query, plz
List-Archive: http://lists.mysql.com/mysql/690
Message-Id: <19990320112551.K17225@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

COUNT(DISTINCT(...)) doesn't work in MySQL (yet).  Try this:

SELECT COUNT(*) FROM table GROUP BY ip;

Tim


On Sat, Mar 20, 1999 at 07:20:50PM +0100, Michal Ludvig wrote:
> INSERT INTO tabtmp SELECT DISTINCT ip FROM table
> and then querying that new table:
> SELECT COUNT(ip) FROM tabtmp