Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.mysql > #6143
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Newsgroups | comp.databases.mysql |
| Subject | Re: Fuzzy searching inside a MySQL DB |
| Date | 2016-03-17 22:13 +0100 |
| Organization | PointedEars Software (PES) |
| Message-ID | <2013108.Ltv2fFrlae@PointedEars.de> (permalink) |
| References | <f6d322a6-47cc-466e-97a7-03c065bf24ec@googlegroups.com> <s2DGy.5057$rQ.4104@fx43.iad> |
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