/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

2 votes280 views1 answer
Add new column not null sql server
SQL
0 vote290 views1 answer
Selecting duplicates
SQL
0 vote295 views1 answer
Get initials name in sql
SQL
12 votes291 views4 answers
Psql command not found
SQL
0 vote289 views1 answer
Sql pad left 0
SQL
2 votes264 views1 answer
How to search table name in stored procedure in sql server
SQL
5 votes276 views2 answers
Postgre insert select
SQL
0 vote274 views1 answer
Assign value to var in SQL
SQL
0 vote292 views1 answer
Sql common columns
SQL
0 vote294 views3 answers
CONTACT FORM SQL
SQL