Returning duplicate entries

[CanMan2004]

Hi all

I want to perform a select * query within phpmyadmin which would return all records where the field 'name' has more than one record with that stored.

For example, my table is called 'people' and the field I want to query is 'name', a snippet of the data is;

id      name
--    ------
1      Dave
2      Edward
3      Sarah
4      Bill
5      Dave
6      Henry
7      Bill
8      Dave

and when I run the query it would return just the records

id      name
--    ------

4      Bill
7      Bill
1      Dave
5      Dave
8      Dave

as there is more than one record with the name 'bill' & 'dave'

Can this be done?

Thanks in advance

Dave

[blear]

try

SELECT * FROM people a, people b WHERE a.id != b.id AND a.name=b.name

[lead2gold]

This might work too:
[code]
SELECT t.id,t.name FROM table t WHERE name IN (SELECT t2.name FROM table t2 GROUP BY t2.name HAVING count(*) > 1)
[/code]

[CanMan2004]

thanks everyone