MariaDB [(none)]> use exampledb;
UPDATE wp_options SET option_value = replace(option_value,'example.net_old','example.net_new');
UPDATE wp_blogs SET domain = replace(domain,'example.net_old','example.net_new');
UPDATE wp_site SET domain = replace(domain,'example.net_old','example.net_new');
UPDATE wp_sitemeta SET meta_value = replace(meta_value,'example.net_old','example.net_new');
UPDATE wp_posts SET post_content = replace(post_content, 'example.net_old', 'example.net_new');
UPDATE wp_posts SET guid = replace(guid, 'example.net_old', 'example.net_new');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'example.net_old','example.net_new');
UPDATE wp_usermeta SET meta_value = replace(meta_value,'example.net_old','example.net_new');
UPDATE wp_2_options SET option_value = replace(option_value,'example.net_old','example.net_new');
UPDATE wp_2_posts SET post_content = replace(post_content,'example.net_old','example.net_new');
UPDATE wp_2_posts SET guid = replace(guid, 'example.net_old', 'example.net_new');
UPDATE wp_2_postmeta SET meta_value = replace(meta_value,'example.net_old','example.net_new');
・・・(マルチサイトの数だけ繰り返す)
UPDATE wp_5_options SET option_value = replace(option_value,'example.net_old','example.net_new');
UPDATE wp_5_posts SET post_content = replace(post_content,'example.net_old','example.net_new');
UPDATE wp_5_posts SET guid = replace(guid, 'example.net_old', 'example.net_new');
UPDATE wp_5_postmeta SET meta_value = replace(meta_value,'example.net_old','example.net_new');