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!
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
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.