# set variables for old and new Domain + Server Folder
SET @oldDomain='OLD_DOMAIN',
	@newDomain='NEW_DOMAIN',
	@oldFolder:='OLD_FOLDER',
	@newFolder:='NEW_FOLDER';

# Update Options
UPDATE wp_options SET option_value = replace( option_value, @oldDomain, @newDomain );
UPDATE wp_options SET option_value = replace( option_value, @oldFolder, @newFolder );

# Update Posts + Postmeta
UPDATE wp_posts SET guid = replace( guid, @oldDomain, @newDomain );
UPDATE wp_posts SET post_content = replace( post_content, @oldDomain, @newDomain );
UPDATE wp_postmeta SET meta_value = replace( meta_value, @oldDomain, @newDomain );

# Updates for WPML Tables
UPDATE wp_icl_string_translations SET value = replace( value, @oldDomain, @newDomain );
UPDATE wp_icl_strings SET value = replace( value, @oldDomain, @newDomain );
UPDATE wp_icl_translation_status SET translation_package = replace( translation_package, @oldDomain, @newDomain );

# Only needed for EWWW Plugin
UPDATE wp_ewwwio_images SET path = replace( path, @oldFolder, @newFolder );