From: Dan Nelson
Date: July 8 2010 8:58pm
Subject: Re: update replace() regex
List-Archive: http://lists.mysql.com/mysql/222121
Message-Id: <20100708205817.GB87422@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 08), Egor Shevtsov said:
> I wonder if possible at all to use replace() together with regex in update
> statement.  I want to be able to update a field of string values and
> replace a 'dash' character with a space in the string.  Something like:
> UPDATE table SET column = replace(column, regex '%-%', ' ') where id = xxx;

You don't need a regex for that.  REPLACE(column, '-', ' ') should do what
you want.

-- 
	Dan Nelson
	dnelson@stripped