/SQL/Mysql search for column name in all tables

Mysql search for column name in all tables

SELECT DISTINCT TABLE_NAME, COLUMN_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%partial_column_name%'
    AND TABLE_SCHEMA='YourDatabase';

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 vote371 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
3 votes329 views1 answer
Search for column name in psql
SQL
2 votes339 views1 answer
Wait delay in sql server
SQL
0 vote351 views1 answer
Select amount weeks between two dates mysql
SQL
17 votes364 views4 answers
Mysql remove ubuntu
SQL
0 vote364 views1 answer
T-sql email validation
SQL
0 vote363 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote344 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
10 votes337 views2 answers
Sql rtrim
SQL
1 vote350 views1 answer
Select tables with name like mysql
SQL