I believe the following will work:
SELECT count(*) FROM <tablename> GROUP BY <field_name>;
--Chris
On Fri, 12 Mar 1999, Holger Rauch wrote:
> Hi!
>
> How can I do without COUNT(DISTINCT <field_name>)?
> (I was looking in the manual, but I couldn't find a solution there.
> In case I overlooked something, I apologize).
>
> Any help will be greatly appreciated! Thanks in advance!
>
> Greetings,
>
> Holger
>
>
>
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread64@stripped
>
> To unsubscribe, e-mail the address in the List-Unsubscribe header.
> For additional commands, e-mail: mysql-help@stripped
>