Rob Raux - Observations

MySQL: Find tables with a given column name

To get a list of tables in mysql which have a given column name (or regex of your choosing, etc.) use the following SQL:

select TABLE_NAME FROM  information_schema.COLUMNS WHERE TABLE_SCHEMA = ‘dbName’ and COLUMN_NAME like ‘%ColName%’;