select * from wp_options where option_name

update wp_options set option_value =http://www.mamicode.com/‘http://cndavy.vicp.net/wordpress‘ where option_name =‘siteurl‘;
update wp_options set option_value =http://www.mamicode.com/‘http://cndavy.vicp.net/wordpress‘ where option_name =‘home‘;

use wordpress;
update wp_options set option_value =http://www.mamicode.com/‘http://127.0.0.1:8080/wordpress‘ where option_name =‘siteurl‘;
update wp_options set option_value =http://www.mamicode.com/‘http://127.0.0.1:8080/wordpress‘ where option_name =‘home‘;

UPDATE wp_options SET option_value = http://www.mamicode.com/REPLACE(option_value,‘旧地址‘,‘新地址‘);

UPDATE wp_posts SET post_content = replace(post_content,‘旧地址‘,‘新地址‘);

UPDATE wp_posts SET post_excerpt= replace(post_excerpt,‘旧地址‘,‘新地址‘);

UPDATE wp_posts SET guid= replace(guid, ‘旧地址‘,‘新地址‘);

WordPress搬家教程：换空间与换域名