Can I vote for just enabling FULL regex support? Let's get it all working (pattern matches (already done), substring replaces, pattern extraction, everything else...).
Shawn Pooly <[EMAIL PROTECTED]> wrote on 06/29/2005 09:31:24 AM: > That I'd love to have a regex_replace available in MySQL !! > > 2005/6/29, Thomas Spahni <[EMAIL PROTECTED]>: > > Hi all, > > > > sometimes life would be easier with a more general 'REPLACE' function > > available. That's when I find mysqlf dumping a database, editing with sed > > and reloading. > > > > My feature request: a string editing function similar to sed's > > s/regexp/replacement/ command to work on the contents of CHAR, VARCHAR and > > TEXT columns. In case of parse errors it should return the unchanged > > string as a default. > > > > What do others think? Any comments are welcome. > > > > Thomas Spahni > >