Perform Search For String Across Entire Database in phpMyAdmin

June 16th, 2014 - Posted by Steve Marks to MySQL, Web Development.

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.

phpMyAdmin Database Search
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.

This entry was posted on Monday, June 16th, 2014 at 12:46 pm by +Steve Marks and is filed under MySQL, Web Development. You can follow any responses to this entry through the RSS 2.0 feed.

Fear not, we won't publish this

Comments (0)

No comments have been left yet. Be the first