UPDATE wp_posts SET post_content = replace( post_content, 'olddomain.com', 'therubyz.com' ) ;
UPDATE wp_posts SET guid = replace( guid, 'olddomain.com', 'therubyz.com' );

UPDATE wp_comments SET comment_author_url = replace( comment_author_url, 'olddomain.com', 'bigmorph.com' );

UPDATE wp_postmeta SET meta_value = replace( meta_value, 'olddomain.com', 'bigmorph.com' );

UPDATE wp_posts SET pinged = replace( pinged, 'olddomain.com', 'bigmorph.com' );



UPDATE wp_ard_download_monitor_files SET filename = replace( filename, 'olddomain.com', 'olddomain.com' ) ;


UPDATE wp_postmeta SET meta_key = replace( meta_key, 'image', 'featured_wide' ) ;

UPDATE wp_posts SET post_type = replace( post_type, 'review', 'testimony' ) ;


UPDATE wp_dev_download_monitor_file_meta SET meta_value = replace( meta_value, '0', '1' );