Re: How to search and replace?

[Bernhard Rieder]

Hello Peter!

I tried today again your code. And for some reason, it doesn't replace the old text with the new target-hyperlink

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

I made this video for you to demonstrate live what your code is doing on my wordpress page.

Here is the Video:
youtu.be/MJHgCrOM8-U

again.. thank you so much for your help, I really do appreciate it!