MySQL Forums
Forum List  »  General

Re: function to replace a substring into a string
Posted by: Sean Nolan
Date: March 31, 2005 09:55AM

You can nest the calls to REPLACE so that you only have to run the update once. So you could do this

UPDATE my_table
SET name = REPLACE(REPLACE(REPLACE(name, ' a ', ''), ' b ', ''), ' c ', '');

Sean

Options: ReplyQuote


Subject
Written By
Posted
Re: function to replace a substring into a string
March 31, 2005 09:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.