finding matches in same table

[doobster]

Hello I have a table that contains information about my members. I was wondering how I can search the table looking for people that have entered the same name in?

I need to compare every row one at a time for the first name and compare it to all other names.

Would a simple nested for loop work?

[zhabala]

You can use SELECT DISTINCT name FROM user_table GROUP BY name HAVING count(*) > 1

This statement will return all names, which are entered more than once. Then you can play with it.

Z.