[HELP] How to compare complex strings???

Any questions involving matching text strings to patterns - the pattern is called a "regular expression."

Moderator: General Moderators

Locked
acco
Forum Newbie
Posts: 13
Joined: Fri Jan 26, 2007 4:32 am

[HELP] How to compare complex strings???

Post by acco »

Hi to everybody, i write to you cause i got a big problem: i got a DB, in mysql, with more than 12000 records, each record has some values as name, surname, city, zip code and address.

My task consists to find all record with the same address. Here is the biggest problem because, while city and zip code are entered with a drop down list, and so there are no possibilities to got differences, the address is entered manually in an input text.

Some examples:
main avenue, 21
main avanue 21
or , worst case: abbreviations:
liberty street, 23
liberty st. 23

So, it depends how the users inserts the address, but the differences can be minimal and refer to the same address. So how can i compare the differences with a bit a tollerance??

I hope that someone can help me.


Thanks and sorry for my bad english ;)
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Post by nickvd »

So, how does this help you?

Posting the same thing twice, even though your first post had some decent suggestions, is only going to upset us to the point of not wanting to help you, no matter how simple your problem is, keep it up and there may be even more problems...
Locked