So,
Every now and then one runs into a situation where one has an idea of a column of a MySQL table.
A quick way to narrow down on the list of tables is to do a search using the part of the column name that one remembers.
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE "%string%";
Where “string” is the string one is searching for.