RE: show duplicate entries

2005-03-27 Thread Tom Crimmins
On Sunday, March 27, 2005 19:48, Louie Miranda wrote: > mysql> select count(*) - count(distinct username,email) as 'duplicate > names' from users; > +-+ >> duplicate names | > +-+ >> 2 | > +-+ > 1 row in set (0.00 sec) > > I got this

show duplicate entries

2005-03-27 Thread Louie Miranda
mysql> select count(*) - count(distinct username,email) as 'duplicate names' from users; +-+ | duplicate names | +-+ | 2 | +-+ 1 row in set (0.00 sec) I got this select syntax to count how many duplicate entries i have. But i dont know