From: bert hubert
Date: March 13 1999 1:40pm
Subject: Re: Select Count(Distinct <fieldname>) from <table>...
List-Archive: http://lists.mysql.com/mysql/159
Message-Id: <Pine.LNX.3.96.990313143845.1055A-100000@vvtp.tn.tudelft.nl>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Sat, 13 Mar 1999, Hank Eskin wrote:

> The only solution I have used to do this is issue:
>   SELECT <fieldname>, count(*) from <tablename> GROUP BY <fieldname>;
> and then get the mysql_NUMROWS (using PHP3).
> 
>  So, is there a way, in one simple query to return this value?

Not yet. I've offered Monty to code it in, but he requested that I wait
for improvements in MySQL making the implementation easier.

A Quick Hack might be possible though. But all it would do is implement
the mysql_numrows trick, discarding the table generated.

regards,
bert hubert.