Re: Fuzzy searching inside a MySQL DB
From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 17 Mar 2016 23:01:38 GMT
Message-ID: <searching-20160318000048_at_ram.dialup.fu-berlin.de>
Date: 17 Mar 2016 23:01:38 GMT
Message-ID: <searching-20160318000048_at_ram.dialup.fu-berlin.de>
Lew Pitcher <lew.pitcher_at_digitalfreehold.ca> writes:
>MySQL supports two forms of pattern matching: the standard SQL "LIKE" verb,
>and the MySQL-specific "REGEXP" verb.
The MySQL standard function SOUNDEX
(SOUNDEX(field)=SOUNDEX('sunflower'))
provides another means to search fuzzyly.
One also could implement the edit/hamming/ levenshtein distance for strings and use it. Received on Fri Mar 18 2016 - 00:01:38 CET