pritam3010 · July 23, 2021 09:41
diff --git a/bulk-find-replace-mysql.php b/bulk-find-replace-mysql.php
 <?php
 /*
 * MySQL Mass Find and Replace
 * Author: Lee Woodman - https://www.linkedin.com/in/leewoodman
 * License: GNU
 */

 // Connect to your MySQL database.
 $hostname = "localhost";
 $username = "root";
 $password = "password";
 $database = "db_name";

 mysql_connect($hostname, $username, $password);

 // The find and replace strings.
 $find = "what_i_need_to_find";
 $replace = "what_i_need_to_replace_with";

 // Test mode
 $test_mode = false;

 // Loop through all tables and columns
 $loop = mysql_query("
    SELECT
        concat('UPDATE ',table_schema,'.',table_name, ' SET ',column_name, '=replace(',column_name,', ''{$find}'', ''{$replace}'');') AS s
    FROM
        information_schema.columns
    WHERE
        table_schema = '{$database}'")
 or die ('Cannot loop through database fields: ' . mysql_error());

 while ($query = mysql_fetch_assoc($loop))
 {
    if ($test_mode)
        echo "{$query['s']}<br/>";
    else
        mysql_query($query['s']);
 }
No results found