searching for duplicate records

[mystrymaster]

I have an address field in my DB and I would like to pull up all the addresses that have multiple entries along with all the corresponding entries. HOW?

I have tried the suggestions suppplied here http://www.phpbuilder.com/board/showthread.php?s=&threadid=10298159&highlight=duplicate but to no avail either

I have used search but no help found

[paulnaj]

Hi mystrymaster,

Your question is a bit vague :queasy:

I would like to pull up all the addresses that have multiple entries

...
SELECT fld, COUNT(fld) AS fld_count
FROM tbl
GROUP BY fld
HAVING fld_count > 1

along with all the corresponding entries.

... is the confusing bit? Corresponding to what?

Paul 🙂