| 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() regex | Egor Shevtsov | 8 Jul |
| • Re: update replace() regex | Dan Nelson | 8 Jul |
| • Re: update replace() regex | Egor Shevtsov | 8 Jul |
