Regexp routines for mysql, implemented without UDF
This functions have no guarantee and are NOT well-tested. Regex lookup is based on REGEXP operator for mysql, thus, all limitations (such as ci-collations) are applicable for them.
Tests
There is a Tests folder, which contains tests set for mysql-unit. Please, refer to it's documentation for more details.
Known issues
- Impossible to use
^or$in expressions. No multiline support. - No support for negative/positive lookaheads/lookbehinds.
- Anything else?
Complexity/Use cases
As it is, full string with length n reconstruction will cause O(n2) complexity. Yeas, that means, you'll have n2 REGEXP calls. So before using this, think twice. However, valid use-case may be to define some variable with this REGEXP_* functions, then use it in query.
If your intention is to use this functionality and it can not be moved from DBMS to application, then probably you're a badass :-)