Useful SQL Queries

sql-queries-wordpress.sql

/* Source: https://codex.wordpress.org/Changing_The_Site_URL */

/* WordPress Address (URL) & Site Address (URL) */ 
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';


/* wp_post */
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');