Re: Does MySQL have fuzzy matching or no?
From: Lew Pitcher <lew.pitcher_at_digitalfreehold.ca>
Date: Fri, 15 Dec 2017 12:46:46 -0500
Message-ID: <p111pu$prk$2_at_dont-email.me>
>
> If you are looking at strings that might sound similar if pronounced, then
> you could use the SOUNDEX() function to match to a pre-determined value,
> or the SOUNDS LIKE operator (which is, effectively, SOUNDEX(a) =
> SOUNDEX(b) ) to match to something else.
> SELECT * FROM table
> WHERE field1 SOUNDS LIKE field2 ;
Date: Fri, 15 Dec 2017 12:46:46 -0500
Message-ID: <p111pu$prk$2_at_dont-email.me>
[Quoted] Lew Pitcher wrote:
> bit-naughty_at_hotmail.com wrote:
>
>> I want to know - if there is a string, say, "poop" in a field in a table, >> and I want to match it against the string "doop", and have the search >> return successful - can I? How, please?
>
> If you are looking at strings that might sound similar if pronounced, then
> you could use the SOUNDEX() function to match to a pre-determined value,
> or the SOUNDS LIKE operator (which is, effectively, SOUNDEX(a) =
> SOUNDEX(b) ) to match to something else.
> SELECT * FROM table
> WHERE field1 SOUNDS LIKE field2 ;
As in
SELECT * FROM table
WHERE field1 SOUNDS LIKE 'doop';
-- Lew Pitcher "In Skills, We Trust" PGP public key available upon requestReceived on Fri Dec 15 2017 - 18:46:46 CET