find replace in post wordpress and worpdressmu

Use this query for wordpressmu users
“UPDATE wp_1_posts SET post_content = REPLACE(post_content, ‘www.test.com’, ‘www.secondtest.com’);”

Use this query for wordpress
“UPDATE wp_posts SET post_content = REPLACE(post_content, ‘www.test.com’, ‘www.secondtest.com’);”

Advertisements