select * from wp_options where option_name

update wp_options set option_value ='http://cndavy.vicp.net/wordpress' where option_name ='siteurl';
update wp_options set option_value ='http://cndavy.vicp.net/wordpress' where option_name ='home';

use wordpress;
update wp_options set option_value ='http://127.0.0.1:8080/wordpress' where option_name ='siteurl';
update wp_options set option_value ='http://127.0.0.1:8080/wordpress' where option_name ='home';

UPDATE wp_options SET option_value = 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, '旧地址','新地址');