MySQL Forums
Forum List  »  General

Re: function to replace a substring into a string
Posted by: mathieu
Date: March 31, 2005 01:45AM

Thanks for your answer !

So, there is no way to replace word of only 1 char length ? I mean, if I use the REPLACE function to replace any 1 char length word, I have to do something like "UPDATE my_table SET name=REPLACE(name,' a ','')" ; and so with each letter ?
Anyway, I think it would be faster than selecting and updating each field 1 by 1.

Options: ReplyQuote


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


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.