npm

mysql-search-replace

PHP script for searching and replacing content in MySQL databases

brewmacoslinux

Try with needOr install directly

Source

About

Database search and replace script in PHP

Commands

mysql-search-replace

Examples

Search for a string in all tables of a database$ mysql-search-replace --host localhost --user root --password mypass --database mydb --search 'oldtext'

Search and replace content across entire database

$ mysql-search-replace --host localhost --user root --password mypass --database mydb --search 'oldtext' --replace 'newtext'

Search and replace in specific table only

$ mysql-search-replace --host localhost --user root --password mypass --database mydb --table users --search 'oldtext' --replace 'newtext'