MySQL Bugs: #1926: REPLACEREGEXP

Bug #1926	REPLACEREGEXP
Submitted:	23 Nov 2003 11:56	Modified:	7 Oct 2005 18:56
Reporter:	Dimitris Kounalakis	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: User-defined functions ( UDF )	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Probably something good that will allow simple XML use with low network
load and low clients' overhead, is to have a REPLACE function with regexp
capabilities like the following:
REPLACEREGEXP(sourcestring,REGEXP condition,replacestring)
where the sourcestring can be a field

How to repeat:
.

Suggested fix:
.

I have created oracle-compatible REGEXP functions as a MySQL UDF module
available here: http://udf-regexp.php-baustelle.de/trac/