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

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]%'