Search the entire database

Question

Is it possible to query or is there a phpmyadmin tool that does this:

Query the entire database for example:

I have the value 23600 and I want him to find that value in the entire bank independent of the table or field in which he is.

Answer 1

In phpMyAdmin, use the search feature:

• Select the Data Base
• Click on the search tab ("Search")
• Choose the terms you want to search for
• Choose the tables you want to search for
• Go!

Answer 2

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('CampoParaBuscar')
        AND TABLE_SCHEMA='SeuBancoDeDados';