Cara Cepat Ganti Replace Kata atau Kalimat di Postingan Wordpress dengan SQL Database Mysql

 Cara Cepat Ganti Replace Kata atau Kalimat di Postingan Wordpress dengan SQL Database Mysql

 Kode sqlnya sebagai berikut:

UPDATE wp_posts SET post_content = replace(post_content, 'Completing the CAPTCHA proves you are a animal and gives you acting admission to the web property.', '');
UPDATE wp_posts SET post_content = replace(post_content, 'If you are on a claimed connection, like at home, you can run an anti-virus browse on your accessory to accomplish abiding it is not adulterated with malware.', '');
UPDATE wp_posts SET post_content = replace(post_content, 'If you are at an appointment or aggregate network, you can ask the arrangement ambassador to run a browse beyond the arrangement attractive for misconfigured or adulterated devices.', '');
UPDATE wp_posts SET post_content = replace(post_content, 'Another way to anticipate accepting this folio in the approaching is to use Privacy Pass. You may charge to download adaptation 2.0 now from the Chrome Web Store.', '');

Mas Pingi 01.21 03/10/2021 maspingi.blogspot.com

Kode SQL Cara Hapus Seluruh Image Attachment Wordpress dengan Database

INGAT! Wajib backup dulu seluruh file wp dan database kalau-kalau ada error!

Langsung saja. masuk ke database, lalu klik menu sql. lalu masukkan kode berikut ini:

DELETE FROM `wp_posts` WHERE `post_type` = "attachment";
DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attached_file";
DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attachment_metadata";

SELESAI

Mas Pingi 09.45 28/09/2021 maspingi.blogspot.com