Regular Expression Functions for MySQL

Wednesday, September 27. 2006

My Regular Exrepssion UDFs for MySQL have been available on MySQL Forge for a while already, now i've taken the time to create a Trac project page for them.

I've implemented the following four functions

* REGEXP_LIKE(text, pattern [, mode])
* REGEXP_SUBSTR(text, pattern)
* REGEXP_INSTR(text, pattern [,position [,occurence [,return_end [,mode]]]])
* REGEXP_REPLACE(text, pattern, replace)

that behave very similar to their Oracle counterparts, using the same regular expression syntax as the MySQL REGEXP operator.

Posted by Hartmut Holzgraefe in MySQL at 05:37 | Comments (2) | Trackbacks (633)

Defined tags for this entry:

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Hi, do you have a Windows version of those UDFs?

Thanks in advance

#1 pabloj (Homepage) on 2006-09-27 13:56 (Reply)

I've been waiting for a REGEXP_REPLACE so long ! Any change to get it include in standard in MySQL ?

#2 Pooly (Homepage) on 2006-09-27 14:13 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Wiki format allowed Standard emoticons like :-) and ;-) are converted to images. E-Mail addresses will not be displayed and will only be used for E-Mail notifications To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry