Often times I've been working with a large database that I'm not very familiar with. I know that a setting is being stored somewhere in the database, but with hundreds of tables, even finding the right table to begin searching can be a lost cause. And while it is possible to run a SELECT query on all tables, you need to know the fields to search for. This is an enormous task if you have hundreds of tables, each of which have different fields and often times containing a large number of fiends.
Thankfully a (relatively) recent project has a solution to the problem. Anywhereindb is a simple php file that does all the grunt work for you. Simply put the file in your htdocs somewhere, navigate to the page in a browser, input your database information, and then you're able to search your entire database for strings. The output is an HTML page with results separated by table, with search terms highlighted.
This is extremely handy and I can't believe how simple they made this to setup (I hate downloading programs, installing, uninstalling, etc).