Possible duplicate:
How do I fuzzy match company names in MYSQL with PHP for autocomplete?
I have a problem with character matching in MySQL.
Suppose I have a table containing a list of names such as elton, angelina, rozy.
If someone asks for names like angalina or rosy - where the user may make a spelling mistake - I want to get the closest names from the table. Which query can be used or what might be possible?
source
share