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’);”

You might also like

how to paginate the single wordpress post
How to exclude images from wordpress post
How to use post or page pagination in wordpress theme
how to show featured posts in wordpress
Fetch the wordpress post paragraph number wise

Leave a Reply

Wordpressapi is developer code book.
wordpressapi on Facebook
© 2010 Wordpressapi. All Rights Reserved. Reproduction without explicit permission is prohibited.