mysql - Delete keyword with link from wordpress post database

Daniel

2022年4月28日 20:42

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

Category Web