Suggestions for Advanced Detection of Duplicates
Date: 2000/04/10
Message-ID: <38F232EE.F7A2A159_at_uscreative.com>#1/1
I appologize for not clarifying exactly what I was looking for in my
previous post.
I was hoping someone could either provide some of their strategies or
suggest resources that covered the detection of duplicate records in a
database. Now the fields in these records may not be EXACTLY identical,
but still refer to the same person.
For example, a possible scenerio would be:
person A enters his information:
Several weeks later the person returns but, having forgotten his
username/password, he creates another new record so that he can access
the app/site/whatever again (the jerk). This time, however, he enters:
Name: Mike Wilkerson
Now, it's the same person, but if you were to attempt to use the
following query to detect if this user was already in the database, it
would no return any rows:
and address = '810 Somewhere #100'
There are many different ways users could enter in their information.
In the above example I could have put Michael instead of Mike or TX
instead of Texas, etc...
I suspect that the detection of duplicates in a database has to be a
Name: Mike Wilkerson
Address: 810 Somewhere St. Apt. 100
City: Dallas
State: Texas
Phone: (512) 555-5555
Address: 810 Somewhere #100
City: Dallas
State: Texas
Phone: 512-555-5555
SELECT name, address, city, state, phone
from tblpeople
where name = 'Mike Wilkerson'
and city = 'Dallas'
and state = 'Texas'
and phone = '512-555-5555'
Thanks for your help,
Michael
Received on Mon Apr 10 2000 - 00:00:00 CEST