Jennifer Zelazny July 2, 2008 2 Comments 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: 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! Tagged: Hints, HOWTOs, phpMyAdmin, SQL 2 thoughts on “Find and Replace With phpMyAdmin (or using SQL)” April 30th, 2009 SQL Tutorials Does anyone know if there is another language or set of commands beside SQL for talking with databases? I’m working on a project and am doing some research thanks Reply April 30th, 2009 SQL Tutorials You know, the thing about SQL is, that there is virtually nothing that can replace it. Does anyone know if a substitute exists for sql? I mean besides MS SQL and Oracle and all that jazz. Thanks. Reply Leave a Reply Cancel ReplyYour email address will not be published. Comment Name * Email * Web site Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed.