Blog

Find and Replace in phpMyAdmin SQL Query

  |   Blog

Under the “SQL” tab in the new version of phpMyAdmin, not the “Query” tab.

UPDATE table_name SET table_field = replace(tablefield,"search_string","replace_string");

WordPress query for reference:

UPDATE wp_posts SET post_content = replace(post_content,"OldDomain.com","NewDomain.com");

Got this from: http://dukeo.com/phpmyadmin-sql-search-and-replace/