Hi All,
We've got a database (legacy, running MySQL 4.1.22 Standard) of
constituents. We want to search through it for duplicates, and I've found
that a good way to generate a list of potential duplicate addresses is to
look for addresses that have matching street numbers, zipcodes, and last
names. For instance, consider the following two records:
John Smith, 123 E Easy St, Springfield, IL 12345
John Smith, 123 East Easy Street, Springfield, IL 12345
They're not a letter for letter match, but if you just compare the last
names ("smith"), and the numeric components of the address ("123" and
"12345"), they would match.
I am wondering, is there a way to search through a table like this (all
fields are varchar):
fname, lname, address, city, state, zip
Using regular expressions, to show any records which match another record on
lastname, street number, and zip? I could do this easily enough in a client
language like PHP, C#, Java, etc., but I was hoping I could do it in SQL
directly. Is this possible?
If it's possible, but only with MySQL 5 or better, I could probably export
the database, and import it into a newer version of MySQL. But it would
naturally be nicest if we can do on the existing server.
Suggestions?
-Josh
--
View this message in context:
http://www.nabble.com/Regular-Expressions-in-MySQL----how-to-show-addresses-that-have-the-same-numbers--tp15923015p15923015.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
