Find and replace text in MySQL using phpMyAdmin

UPDATE table SET field = replace(field,"textA","textB");

In WordPress
UPDATE wp7w_posts SET post_content = replace(post_content,"©","©");

Leave a Reply

Your email address will not be published. Required fields are marked *