select count(distinct(user)) from results;
Cheers, Jan -- Janice Wright Ingenta plc [EMAIL PROTECTED] Tel: +44 (0) 01865 799114 http://www.ingentaselect.com/ Sometime recently Daniel Rossi said: > what ever happend to a unique primary key like userID ? > > >>> "gord barq" <[EMAIL PROTECTED]> 08/11/03 11:15am >>> > I have a table I'm using for logging purposes with a schema like: > > create table results ( > user varchar(255) > .... > ); > > Where user is not a unique field and I want to find out how many unique > users there are in the table. > > I want to do something like: > > select count(count(*)) from results group by user; > > But that doesn't work.. > > Any ideas? > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]