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
9 months
2022-04-28T15:42:38-05:00
2022-04-28T15:42:38-05:00 0 Answers
0 views
0
Leave an answer