Using a wildcard in an update?

Posted by Paul Tomblin on Stack Overflow See other posts from Stack Overflow or by Paul Tomblin
Published on 2010-04-23T13:09:45Z Indexed on 2010/04/23 13:23 UTC
Read the original article Hit count: 262

Filed under:
|

I want to go through a table, and change all instances of 'notify4-N' to 'notify5-N', where N is a number from 1-9. Is there a way to do that in SQL? It would be easy in perl, but I'm not sure the customer even has perl on his servers.

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle