WordPress 修改 Domain Name (網域)、SiteUrl (網站位置、網址) 快速指令。

開啟 phpMyadmin 或是其他的 DataBase 管理工具，貼上這句 SQL 執行，記得要修改範例中的新舊網址。

範例中的

舊的網址: https://mradam.keeptouch.me

新的網址: https://mradam.keeptouch.me

UPDATE wp_options SET option_value = replace(option_value, \'https://mradam.keeptouch.me\', \'https://mradam.keeptouch.me\') WHERE option_name = \'home\' OR option_name = \'siteurl\';

UPDATE wp_posts SET guid = replace(guid, \'https://mradam.keeptouch.me\',\'https://mradam.keeptouch.me\');

UPDATE wp_posts SET post_content = replace(post_content, \'https://mradam.keeptouch.me\', \'https://mradam.keeptouch.me\');

UPDATE wp_postmeta SET meta_value = replace(meta_value,\'https://mradam.keeptouch.me\',\'https://mradam.keeptouch.me\');