PhpMyAdmin
UPDATE `wp_options` SET `option_value` = REPLACE( `option_value` , 'www.', '' ); UPDATE `wp_postmeta` SET `meta_value` = REPLACE( `meta_value` , 'www.', '' ); UPDATE `wp_posts` SET `guid` = REPLACE( `guid` , 'www.', '' );
PhpMyAdmin
UPDATE `wp_options` SET `option_value` = REPLACE( `option_value` , 'www.', '' ); UPDATE `wp_postmeta` SET `meta_value` = REPLACE( `meta_value` , 'www.', '' ); UPDATE `wp_posts` SET `guid` = REPLACE( `guid` , 'www.', '' );