Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #16678

Re: Fuzzy searching inside a MySQL DB

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 <PointedEars@web.de>
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> (permalink)
References <f6d322a6-47cc-466e-97a7-03c065bf24ec@googlegroups.com> <ncf3pd$a28$1@dont-email.me> <3171cc72-16d1-4b88-bcd9-a3a3b4127bc8@googlegroups.com> <ncpeeb$ioi$1@dont-email.me> <1596044.moDK1lYXQJ@PointedEars.de> <2d87c8c4-e064-4d39-ae61-db1fef22406b@googlegroups.com> <ncrjss$fvo$1@dont-email.me>
Reply-To Thomas 'PointedEars' Lahn <php@PointedEars.de>
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

Show key headers only | View raw

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 
<http://www.zend.com/en/yellow-pages/ZEND024953> | Twitter: @PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Fuzzy searching inside a MySQL DB bit-naughty@hotmail.com - 2016-03-17 10:16 -0700
  Re: Fuzzy searching inside a MySQL DB Jerry Stuckle <jstucklex@attglobal.net> - 2016-03-17 13:34 -0400
  Re: Fuzzy searching inside a MySQL DB "R.Wieser" <address@not.available> - 2016-03-17 18:37 +0100
  Re: Fuzzy searching inside a MySQL DB Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2016-03-17 14:53 -0400
    Re: Fuzzy searching inside a MySQL DB Dr Eberhard Lisse <nospam@lisse.NA> - 2016-03-22 16:35 +0200
  Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-17 16:27 -0400
    Re: Fuzzy searching inside a MySQL DB bit-naughty@hotmail.com - 2016-03-21 11:09 -0700
      Re: Fuzzy searching inside a MySQL DB Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2016-03-21 14:22 -0400
      Re: Fuzzy searching inside a MySQL DB "R.Wieser" <address@not.available> - 2016-03-21 19:24 +0100
      Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-21 14:30 -0400
        Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-21 23:04 +0100
          Re: Fuzzy searching inside a MySQL DB bit-naughty@hotmail.com - 2016-03-22 00:31 -0700
            Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-22 10:15 -0400
              Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-22 21:53 +0100
                Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-23 13:26 -0400
                Re: Fuzzy searching inside a MySQL DB bit-naughty@hotmail.com - 2016-03-25 00:03 -0700
                Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-25 11:52 -0400
                Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-25 19:26 +0100
                Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-25 15:51 -0400
                Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-25 21:52 +0100
                Re: Fuzzy searching inside a MySQL DB Jerry Stuckle <jstucklex@attglobal.net> - 2016-03-25 20:20 -0400
                Re: Fuzzy searching inside a MySQL DB Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2016-03-25 12:11 -0400
                Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-25 08:49 +0100
                Re: Fuzzy searching inside a MySQL DB gordonb.3vp6x@burditt.org (Gordon Burditt) - 2016-03-26 13:44 -0500
                Re: Fuzzy searching inside a MySQL DB bit-naughty@hotmail.com - 2016-03-27 12:42 -0700
                Re: Fuzzy searching inside a MySQL DB Mike Mellen <mmellen@intellikey.com> - 2016-03-28 15:02 -0400
                Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-28 01:48 +0200
            Re: Fuzzy searching inside a MySQL DB Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-22 21:50 +0100

csiph-web