Search Entire Database for a single value in all MySQL database tables in one go

[PriyankaGupta]

This snippet can search for a value in all MySQL database tables. It can connect to a given MySQL database and retrieves the list of all database tables. This snippet queries each of the tables to search of a given values in all columns of the table. It sets an array variable with the list of tables and columns on which the given value was found.

PHP Snippet


Sample: $obg = new searchEntireDB(DBName, userName, pswd, columnName, targetText);<br><br>

[Guest]

There is a Schemas tab on the side menu bar, click on the Schemas tab, then double click on a database to select the database you want to search. Then go to menu Database - Search Data, and enter the text you are searching for, click on Start Search.