Path: csiph.com!feeder.erje.net!2.us.feeder.erje.net!news2.arglkargh.de!news.mixmin.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Thomas 'PointedEars' Lahn Newsgroups: comp.lang.php Subject: Re: Fuzzy searching inside a MySQL DB Date: Tue, 22 Mar 2016 21:53:38 +0100 Organization: PointedEars Software (PES) Lines: 16 Message-ID: <4561092.OFe0Ho86XT@PointedEars.de> References: <3171cc72-16d1-4b88-bcd9-a3a3b4127bc8@googlegroups.com> <1596044.moDK1lYXQJ@PointedEars.de> <2d87c8c4-e064-4d39-ae61-db1fef22406b@googlegroups.com> Reply-To: Thomas 'PointedEars' Lahn Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7Bit X-Trace: solani.org 1458680019 8817 eJwNyskRACAIBLCWFgXEcjj7L0G/mchW0jysoiwjo+F5iCLXcLqhxz7c5RtUmPVfBdDVYoaLBy4SEU4= (22 Mar 2016 20:53:39 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Tue, 22 Mar 2016 20:53:39 +0000 (UTC) User-Agent: KNode/4.14.2 X-User-ID: eJwNyEkBwDAIBEBLnAuRA6T4l9A8Z1zBmDA4zNeXu+orLLUs3Nx5p5KOmsg1YdJ5Q3ZqbkRlslCyPXcXYn5UdhVC Cancel-Lock: sha1:MKbFzaBu4fxkB3Le2oX5ciMTbzk= X-NNTP-Posting-Host: eJwFwYERAEEEBLCWGCzKecf2X8InYVC8dAQ8GMwW3rfM6nijV6JjPtoj5IjpEmjpS18txA8mqBEP Xref: csiph.com comp.lang.php:16678 Mike Mellen wrote: > On 3/22/2016 3:31 AM, bit-naughty@hotmail.com wrote: >> ...sorry, I'm a little confused - do levenshtein() and similar_text() >> ship WITH MySQL? > > No, but there are PHP levenshtein() and similar_text() functions. There > is a soundex() function in mySQL, which is why I suggested it. AISB, from the OP follows that Soundex is not the correct solution here. -- PointedEars Zend Certified PHP Engineer | Twitter: @PointedEars2 Please do not cc me. / Bitte keine Kopien per E-Mail.