Ever need to find and replace something in your WordPress database? (perhaps you changed domain names and have the old domain name or folder structure hard coded into some of your posts) You can easily update your database by using phpMyAdmin or by using the following code in any SQL interface:
SQL:
UPDATE wp_posts SET post_content = REPLACE(post_content,"http://olddomain.com/blog","newdomain.com/");
The first part of the command says "update the database table wp_posts" (where your content is stored). The later part of the command says "use the field "post_content" (where all your actual post content is stored" and then find "http://olddomain.com/blog" and replace it with "http://newdomain.com". You can find anything (not limited to domain name) and replace it with anything as well. This is a great time saver!
Comments, Pingbacks and Tracebacks
(Comment icons use gravatars. Sign up for a gravatar so you can be cool too.)
Leave a Reply