MySQL Forums
Forum List  »  Newbie

Re: How to search and replace?
Posted by: Peter Brawley
Date: April 25, 2018 07:18PM

> The code doesn't allow me to add a hyperlink to the new text-replacement.

set @newtxt = concat( "new link is ", "https:www.here.com" );
update wp_posts set post_content = replace(post_content,'oldtext', @newtxt );

> What's the code for the pages?

Depends on how the pages are stored.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to search and replace?
April 25, 2018 07:18PM


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.