selfish
8/10/2014 - 1:07 PM

Tables with column X

Find MySQL Tables containing a column by name

tables-by-column.mysql
content_copyfile_download
SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('columnA','ColumnB')
  AND TABLE_SCHEMA='YourDatabase';
  
-- OR:

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%columnA%'
  AND TABLE_SCHEMA='YourDatabase';