Scalar. Returns a given string with the first occurrence of a match for a POSIX regular expression pattern replaced with a second, specified string.
If string does not contain a match for regex, the function returns string with no replacements. If regex is not a valid regular expression, the function returns NULL.
INSERT INTO OutStream SELECT REGEXP_REPLACE(InStream.src, InStream.regexp, InStream.replace_str), InStream.src, InStream.regexp, InStream.replace_str FROM InStream;