You might also find SOUNDEX useful. http://dev.mysql.com/doc/mysql/en/String_functions.html
Peter > -----Original Message----- > From: Duncan Hill [mailto:[EMAIL PROTECTED] > Sent: 21 July 2004 15:10 > To: [EMAIL PROTECTED] > Subject: Re: Mailing Address Deduplication > > > On Wednesday 21 July 2004 15:04, Andrew Kuebler might have typed: > > I know this is not necessarily a MySQL question, but everyone on this > > listserv is always so helpful and I was wondering if anyone had any > > pointers on how to deduplicate a list of mailing address since there can > > be so many inconsistencies on how an address can be written > (road vs rd vs > > rd., etc). I was thinking that I probably needed to find a way to > > standardize the addresses using USPS standards and then > deduplicate. Am I > > perl String::Compare may be what you need. Colleague of mine has > been using > it to determine if UK addresses are the same by weighting the postcode > heavily, and then letting the comparison of the address determine dupes. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]