mysql – Delete keyword with link from wordpress post database
I have a problem and if anyone can help thanks in advance.
I want to remove some stuffed keyword with link from my wordpress post table example of link
I have some posts since 2011 and it`s quite hard to edit all those posts to remove the links….
I wonder if i can use this code
UPDATE wp_posts SET post_content = replace(post_content, '<a href="example.com/keyword/">keyword</a>', '' ) ;
Any help is most welcome