wordpress批量修改域名SQL

UPDATE wow_options SET option_value = REPLACE(option_value, 'https://test.cn' ,'http://test.loc') WHERE option_name = 'home' OR option_name = 'siteurl';

/*更正文章中内部链接及附件的地址：*/

UPDATE wow_posts SET post_content = REPLACE(post_content, 'https://test.cn' ,'http://test.loc');

/*更正wordpress文章默认的永久链接：*/

UPDATE wow_posts SET guid = REPLACE(guid, 'https://test.cn' ,'http://test.loc');