Finding duplicate fields - MySQL

I have a table with about 6 columns, one of which is first_name, and another of which is last_name.

I am trying to pull out any records that have the same first_name and last_name column values.

Can anyone help me with a query that would do this? I know this should be simple, but I am at a loss!

Thanks!!

The following sql should list all first name, last name combinations that appear more than once in the database.

select first_name, last_name, count()
from yourtable
group by first_name, last_name
having count() > 1

Well, it's been a while since I"ve tried to do this, but you could do a select like this:

SELECT *, concat( last_name, ",", first_name ) as full_name order by full_name;

Then you could loop through the results and only print lines which have the same full_name as the previous line.

Hope this helps.

-Rich

Awsome! That first suggestion nailed it!
Thanks for the help, this has been bugging me.

Steve D wrote:

The following sql should list all first name, last name combinations that appear more than once in the database.

select first_name, last_name, count()
from yourtable
group by first_name, last_name
having count() > 1