Find tables in MySQL with specific column names

Public

This command will show all the tables in MySQL with specific column names

Get raw version
sql
  1. SELECT DISTINCT TABLE_NAME
  2. FROM INFORMATION_SCHEMA.COLUMNS
  3. WHERE COLUMN_NAME IN ('columnA','ColumnB')
  4. AND TABLE_SCHEMA='YourDatabase';