Search the entire database

1

You can do a query or there is some phpmyadmin tool that does this:

Query the entire database for example:

I have the value 23600 and I want it to find this value in the whole bank regardless of the table or field it is in.

    
asked by anonymous 27.03.2014 / 16:07

3 answers

8

In phpMyAdmin, use the search feature:

  • Select the Database
  • Click the Search tab
  • Choose the terms you want to search for
  • Choose the tables you want to search
  • Go!

    
27.03.2014 / 16:15
1

Silvio, this LINK , contains a very detailed example of how to do this. The article is in English, but it is very practical. I recommend that you index the fields that are relative to the search, that is, the ones that should be most relevant, to gain a little more performance in that case.

    
27.03.2014 / 16:13
0
SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('CampoParaBuscar')
        AND TABLE_SCHEMA='SeuBancoDeDados';
    
15.10.2014 / 15:07