mysql - phpmyadmin: query to search/replace term -

mysql - phpmyadmin: query to search/replace term -

i have table named wp_posts , column named post_content.

within table, want search through every entry of post_content , find instances of <em> , replace <em class="title">.

how can using phpmyadmin? have 50,000+ rows in table query should ideally not crash server.

you can sql:

update wp_posts set post_content = replace(post_content, '<em>', '<em class=\"title\">');

mysql database search replace phpmyadmin