Re: Does MySQL have fuzzy matching or no?
From: Axel Schwenke <axel.schwenke_at_gmx.de>
Date: Fri, 15 Dec 2017 16:50:35 +0100
Message-ID: <p10r0c$923$1_at_dont-email.me>
>> On 15.12.2017 13:22, 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?
>>
>> MySQL 5.7 now supports pluggable parsers for fulltext search. One is the
>> n-gram parser that breaks field and search phrase into n-grams. A match on
>> such a fulltext index would then find similar texts, too. In your case
>> "doop" would match the trigram "oop" or the bigrams "oo" and "op" in "poop".
>>
>> https://mysqlserverteam.com/innodb-full-text-n-gram-parser/
>>
> old fashioned [LIKE '%oop'] ??
Date: Fri, 15 Dec 2017 16:50:35 +0100
Message-ID: <p10r0c$923$1_at_dont-email.me>
On 15.12.2017 15:45, The Natural Philosopher wrote:
> On 15/12/17 13:39, Axel Schwenke wrote:
>> On 15.12.2017 13:22, 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?
>>
>> MySQL 5.7 now supports pluggable parsers for fulltext search. One is the
>> n-gram parser that breaks field and search phrase into n-grams. A match on
>> such a fulltext index would then find similar texts, too. In your case
>> "doop" would match the trigram "oop" or the bigrams "oo" and "op" in "poop".
>>
>> https://mysqlserverteam.com/innodb-full-text-n-gram-parser/
>>
> old fashioned [LIKE '%oop'] ??
It's not the same. Not even near.
Come up with the LIKE clauses for finding a trigram match for the search phrase "naturalistic philosophy". And don't forget to calculate a rank(!) for all the matches. Received on Fri Dec 15 2017 - 16:50:35 CET