Mysql find tables with column name

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Source: stackoverflow.com

Similar codes

0 vote152 views1 answer
Get initial in sql
SQL
0 vote137 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote160 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote152 views1 answer
Except in sql alchemy
SQL
0 vote149 views1 answer
Postgresql print sessions using the database
SQL
0 vote160 views1 answer
Mysql conf.d exampel
SQL
-2 votes137 views3 answers
Oracle tablespace usage
SQL
-1 vote96 views1 answer
Oracle db list usernames
SQL
4 votes150 views1 answer
Create column mysql terminal
SQL
0 vote150 views1 answer
Shell script to log mysql cpu usage
SQL