acco Posted January 26, 2007 Share Posted January 26, 2007 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:[quote]main avenue, 21[/quote][quote]main avanue 21[/quote]or , worst case: te abbreviation:[quote]liberty street, 23[/quote][quote]liberty st. 23[/quote]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 ;) Link to comment https://forums.phpfreaks.com/topic/35787-how-to-compare-complex-strings/ Share on other sites More sharing options...
Nelak Posted January 26, 2007 Share Posted January 26, 2007 have u tried the mysql LIKE statement? Link to comment https://forums.phpfreaks.com/topic/35787-how-to-compare-complex-strings/#findComment-169586 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.