/SQL/Get table which have specific columns in mysql

Get table which have specific columns in mysql

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

Source: stackoverflow.com

Similar codes

3 votes243 views1 answer
Two select sql
SQL
0 vote219 views1 answer
Sql right characters
SQL
0 vote224 views1 answer
Oracle execute immediate quotes
SQL
1 vote250 views4 answers
Get week day from date in sql
SQL
0 vote238 views2 answers
Sql update multiple tables
SQL
0 vote220 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote219 views1 answer
How to delete record sql delphi
SQL
4 votes248 views1 answer
Group by mysql and concatenate string
SQL
0 vote259 views2 answers
Greater than sql server
SQL
0 vote218 views1 answer
Zsh: command not found: mysql mamp
SQL