Knowledge base dedicated to Linux and applied mathematics.
Home > Linux > Tip of the day > phpMyAdmin: Search and Replace in MySQL database
All the versions of this article: <English> <français>
How to search and replace in MySQL database with phpMyAdmin ?
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 :-)