/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

13 votes309 views3 answers
Uninstall mysql centos 7
SQL
25 votes415 views4 answers
Import mysql dump command line
SQL
0 vote299 views1 answer
Big query add table rows to another table
SQL
2 votes321 views1 answer
Sql ignore accents
SQL
1 vote321 views2 answers
Mysql spring boot application.properties
SQL
0 vote378 views1 answer
Dataframe lambda elif
SQL
0 vote357 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
7 votes361 views6 answers
Mysql group concat
SQL
7 votes355 views1 answer
Sql disable safe mode
SQL
0 vote285 views1 answer
Oracle sql developer script output limit
SQL