Permisi, saya ingin bertanya perintah SQL untuk:<\/p>\n
1. Hapus semua yang ada di field ‘guid’ di tabel wp_options
\n(catatan: field ‘guid’ tidak ikut terhapus tp cuma datanya saja’).<\/p>\n
2. Pada field ‘guid’ masukkan kata ‘http:\/\/domain.com\/?p=’ diikuti field ID-nya (setelah “=” tanpa spasi), hasilnya (misal): http:\/\/domain.com\/?p=7847<\/a> di field ber-ID: 7847.<\/p>\n Mohon bantuannya, kakak. Mohon bantuannya..<\/p>\n","protected":false},"template":"","class_list":["post-31457","topic","type-topic","status-closed","hentry","topic-tag-guid","topic-tag-permalink","topic-tag-sql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/id.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/31457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/id.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/id.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/id.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/31457\/revisions"}],"wp:attachment":[{"href":"https:\/\/id.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=31457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nCeritanya:
\ndomain_lama..c0m<\/a> berisi 17.000 posting -> hosting ga kuat -> pindah hosting baru -> database.sql domain_lama.com dimasukkan ke domain-baru..c0m<\/a><\/p>\n