skip to Main Content

How to replace a string in wordpress in all posts with PHPMyAdmin

How To Replace A String In Wordpress In All Posts With PHPMyAdmin
mcmurryjulie / Pixabay

Use this SQL Query in phpmyadmin and adapt to your need. This usecase removes all occurences of [:de] in any part of the posts content:

UPDATE UUQf09E_posts SET post_content = REPLACE( post_content, '[:de]', '' ) WHERE post_content LIKE '%[:de]%'

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.

Back To Top