Re: Fuzzy searching inside a MySQL DB

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: _at_PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.