I'm doing a search in a mysql database where I compare words, like this:
SELECT .. FROM .... WHERE word IN ('word1', 'word2', ...)
It all works like a charm, but I would like to expand the search to be 'fuzzy'. So that if word='matchbox' and word1='match' would generate a hit.
Any suggestions?
Thanks,
Andrew
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
SELECT .. FROM .... WHERE word IN ('word1', 'word2', ...)
It all works like a charm, but I would like to expand the search to be 'fuzzy'. So that if word='matchbox' and word1='match' would generate a hit.
Any suggestions?
Thanks,
Andrew
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->