Find and replace text in MySQL using phpMyAdmin

UPDATE table SET column = replace(column,"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 *

Shares