Similar search results

[pederdin]

I have a column with names

1. John Doe
2. Mary Parker
3. Thomas Smith

I now want to make search. The search string I enter is

Tomas

And I want to get row number three as a result. I have tried soundex('string') but as I see it I can only make it work on the whole field, and as "Tomas" does note sound like the complete "Thomas Smith" I don't get any results. One solution could be to have firstname and lastname in seperate columns, but I would want the feature to work so that when I search for "Anne" I get the result "Mary-Ann" as well. So just seperating firstname and lastname won't help me 100%.

Is there a way to see if a field CONTAINS something that sounds like '$string'?

[paulnaj]

Have you read the manual entry for soundex in the manual. There are plenty of user comments that seem to cater for your problem.

Paul 🙂

[dalecosp]

Wowsa ... blast from the past. For the benefit of the Google searcher, there are more functions that might help, including [man]similar_string/man, [man]metaphone/man, and [man]levenshtein/man.