Path: csiph.com!weretis.net!feeder4.news.weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Thomas 'PointedEars' Lahn Newsgroups: comp.databases.mysql Subject: Re: Fuzzy searching inside a MySQL DB Date: Thu, 17 Mar 2016 22:13:32 +0100 Organization: PointedEars Software (PES) Lines: 23 Message-ID: <2013108.Ltv2fFrlae@PointedEars.de> References: Reply-To: Thomas 'PointedEars' Lahn Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8Bit X-Trace: solani.org 1458249213 32255 eJwNxcEBgEAIA7CVKNAK45wo+4+g+YQhaK4UlVyuIeBd9OP1jMqgnjytzuLfhOJGgVuW8c4H8aQPvA== (17 Mar 2016 21:13:33 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Thu, 17 Mar 2016 21:13:33 +0000 (UTC) User-Agent: KNode/4.14.2 X-User-ID: eJwNxskRACAIBLCWuBawHETpvwT9ZAJ19g5zuGEwu3ae2hxKFM7CuEvbkVdV7jexuIyiqWzyr860UEBsmuUBQsMU6Q== Cancel-Lock: sha1:jWmt38fVCKNEmx9o4W721SYx2PA= X-NNTP-Posting-Host: eJwFwYEBgDAIA7CXREoZ58Cw/59gEk7jTTCIUGja1/P1K7CHeY0HeazbRp8qYF2L2ppnR/UDI+wRmQ== Xref: csiph.com comp.databases.mysql:6143 Lew Pitcher wrote: > "REGEXP" searches are more versatile, but not supported (AFAIK) outside of > MySQL and it's variants. As a quick Google search for “sql regular expression” shows, at least the following other SQL implementations have it: - DB2 for i 7.1 and 7.2 (REGEXP_*(…)) - Firebird ([NOT] SIMILAR TO pattern) - Oracle/PLSQL (REGEXP_*(…)) - PostgreSQL ([NOT] SIMILAR TO $pattern) You can also have it in Transact-SQL and SQLite, but you need to hack it yourself. See also: p. -- PointedEars Zend Certified PHP Engineer | Twitter: @PointedEars2 Please do not cc me. / Bitte keine Kopien per E-Mail.