Find and Replace in phpMyAdmin SQL Query
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: https://dukeo.com/phpmyadmin-sql-search-and-replace/