List:General Discussion« Previous MessageNext Message »
From:Egor Shevtsov Date:July 8 2010 9:01pm
Subject:Re: update replace() regex
View as plain text  
Thanks Dan,
I tested it just now. It works perfectly.

Dan Nelson wrote:
> 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.
>
>   

Thread
update replace() regexEgor Shevtsov8 Jul
  • Re: update replace() regexDan Nelson8 Jul
    • Re: update replace() regexEgor Shevtsov8 Jul