Searching For Modules In a DB

carlosinfl · 08-11-2010, 04:02 PM

I have a database called 'gaming' and with in that database there are several tables and data. I was asked to find a module called 'ako ldap' and disable it (setting it from 1 to 0). My question is how in MySQL do I search for a string if I don't even know what table to search in? I know how to search using the 'select' statement as long as I know where the table data is. In this case I only know which database but nothing more except what I am looking for.

Can anyone please point me in the right direction?

frankbell · 08-11-2010, 09:22 PM

I had forgotten that I used to know this:

Use a "join."

Here is some information on join.

I never used it in an SQL query, but I remember now that most report software for databases uses joins to select information across tables. I don't know enough to give you examples, but I hope the link can get you headed in the right direction.