phpMyAdmin: Search and Replace in MySQL database

Click on your database name, you want to run the search and replace through. Next, click on the SQL tab, in the SQL box, enter something like:

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

For example:

UPDATE table_spip_articles SET text = replace(text,"<pre><code class="language-bash">","<pre><code class="language-python">");

and execute :-)