mysql – Delete keyword with link from wordpress post database

Question

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

<a href="http://example.com/keyword/">keyword</a>

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

Regards

Daniel

0
Daniel 2 months 2022-04-28T15:42:38-05:00 0 Answers 0 views 0

Leave an answer

Browse
Browse