Find Duplicates with Match Against
We have a table with a 'name' field in our 'members' table, and it could have data such as "Mike G." all the way to "Mr. Michael Godfrey III"
Finding duplicate records based on the 'name' field has been difficult for me to figure out. I've created a duplicate table 'members2' to help find them using MATCH AGAINST, but haven't had much luck.
Another good search by field is 'zip'.
If I could search for duplicates with a MATCH AGAINST on 'name' and a direct match for 'zip' I might have something.
I've currently got a direct match on both using:
SELECT name, zip, count(*) cnt
GROUP BY name, zip
HAVING cnt > 1
ORDER BY cnt DESC;