Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.mysql > #6143
| Path | csiph.com!weretis.net!feeder4.news.weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail |
|---|---|
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
| 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> (permalink) |
| References | <f6d322a6-47cc-466e-97a7-03c065bf24ec@googlegroups.com> <s2DGy.5057$rQ.4104@fx43.iad> |
| Reply-To | Thomas 'PointedEars' Lahn <php@PointedEars.de> |
| 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 |
Show key headers only | View raw
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: <http://trentrichardson.com/2008/10/23/exploring-various-sql-regex-syntax/> p. -- 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.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
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 Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2016-03-17 22:13 +0100 Re: Fuzzy searching inside a MySQL DB Dr Eberhard Lisse <nospam@lisse.NA> - 2016-03-22 16:35 +0200
csiph-web