/mysql-search-replace

Search and replace text on an entire mysql database

Primary LanguagePHPOtherNOASSERTION

Search and replace text on an entire mysql database

This class written in php, search a text massively on an entire mysql database and replace it by other one.

The usage is very simple:

// Create an instace of the class
$mysqlSearchAndReplace = new mysqlSearchAndReplace("myDatabase", "localhost", "root", "");

// Simple search and replace
$mysqlSearchAndReplace->searchAndReplace("old text", "new text");

// Case sensitive = true
$mysqlSearchAndReplace->searchAndReplace("Old Text", "New text", true);

// We specify the tables where search
$mysqlSearchAndReplace->searchAndReplace("old text", "new text", true, array('tableOne', 'tableTwo'));

Autor