I finished implementing the missing optional REGEXP function parameters today, all regular expression functions should now work as similar to their Oracle counterparts as possible with the following restrictions:
* The MySQL UDF API predates the extended character set support added with MySQL 4.1 and so UDF functions have no idea about charsets and collations at all. As a consequence the functions for now are always case sensitve by default and are always assuming their input to be Latin1 encoded
* Only the 'c' and 'i' pattern modifiers for case sensitive and insensitive matching are implemented yet, the 'm' and 'n' modifiers for multi line input are not yet supported
* I haven't tested back references on REGEXP_REPLACE() yet. They may or may not work, as i borrowed the actual implementation from the PHP source i'm not really sure about whether it takes care of this or not
Anyway, the REGEXP UDFs are hosted on http://udf-regexp.php-baustelle.de/ and the new 1.0 release is available here