finding all rows in DB that have same value?

Hello..

I've got a small MySQL table that looks something like this:

ID TELEPHONE NAME

All the ID's are unique, however there could be 2 or 3 rows in the DB that have the same tel#.

How can I get a list of all the rows that have multiple occurances of the same tel#? (ie: if the tel# is only listed once, i don't want that row...)

Thanks,

-dr

SELECT
  telephone, COUNT(telephone)
FROM tablename
GROUP BY telephone
HAVING COUNT(telephone) > 1

try that

Perfect!

Thanks a lot!

-dr