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