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.
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.
In phpMyAdmin, use the search feature:
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.
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('CampoParaBuscar')
AND TABLE_SCHEMA='SeuBancoDeDados';