Perform Search For String Across Entire Database in phpMyAdmin
Searching for a word or phrase within one MySQL table can be easily achieved with an SQL query. Doing a search across a whole database becomes a little bit more complex should you wish to do this with a query. Thankfully, if you use phpMyAdmin there is a built-in feature that enables you do just this.
Simply login to phpMyAdmin, select the database you wish to perform the search in and click the ‘Search‘ tab.
From here you’ll be able to enter the string that you wish to search for, and choose which tables within the database to include in the search.