MySQL Forums
Forum List  »  General

Re: SELECT/LIKE works but UPDATE/REPLACE doesn't
Posted by: Peter Brawley
Date: October 24, 2016 09:33PM

> I hadn't seen anything to suggest that REPLACE could not work with wild cards

If replace() supported wildcards, the manual page would mention them.

> how I target a piece of text in a large VARCHAR field where I cannot predict what comes after or before

Standard programming. Find the position of the target string with locate(), refer to what follows with substr().

Options: ReplyQuote


Subject
Written By
Posted
Re: SELECT/LIKE works but UPDATE/REPLACE doesn't
October 24, 2016 09:33PM


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.