stun-migration.sql

-- Run this on the cloned staging database (to become production)

UPDATE wp_options 
SET option_value = REPLACE( option_value, 'http://stage.stuncreative.com', 'http://www.stuncreative.com' )
WHERE option_value LIKE 'http://%';

UPDATE wp_posts
SET post_content = REPLACE( post_content, 'http://stage.stuncreative.com', 'http://www.stuncreative.com' );

UPDATE wp_postmeta
SET meta_value = REPLACE( meta_value, 'http://stage.stuncreative.com', 'http://www.stuncreative.com' );