List:General Discussion« Previous MessageNext Message »
From:Egor Shevtsov Date:July 8 2010 7:37pm
Subject:update replace() regex
View as plain text  
Hi ALL,
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;

Obviously, regex doesn't work inside of replace().
Any suggestions, guys?
Thanks,
Igor   
Thread
update replace() regexEgor Shevtsov8 Jul
  • Re: update replace() regexDan Nelson8 Jul
    • Re: update replace() regexEgor Shevtsov8 Jul