Software and Applications (non-game)
Database Programming
Acronyms & Abbreviations
Proper Addressing

Is there a way to identify similar but not exact match values in a database for example 243 w main st and 243 west main street thanks?

User Avatar
Wiki User
December 03, 2005 4:04PM

If you knew that the address (taking your example) contained the words "243" and "main" you could use wild card search in RDBMS select * from where like "%243%main%" This will list all records where the address contains 243 and main. It will not find an address that has both the words but main occurs before 243. To cater to that case also you may want to write the query as select * from where like "%243%" and like "%main%" This query may be costlier (would take longer to execute and consume more computer resources) than the previous one because it uses two conditions instead of one in the first example.