/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 vote120 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
1 vote171 views1 answer
Mysql monthname
SQL
1 vote103 views1 answer
SQLSTATE[HY000] [2002]
SQL
7 votes111 views2 answers
Oracle sql drop index
SQL
0 vote174 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
2 votes90 views1 answer
Sql to char function with date
SQL
1 vote99 views3 answers
Execute sp in sql server
SQL
0 vote60 views2 answers
Postgresql could not start server mac
SQL
0 vote103 views2 answers
Sql server select first day of previous year
SQL
0 vote104 views1 answer
Python mysql executemany
SQL