/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 vote119 views1 answer
Optimize sql query
SQL
0 vote127 views1 answer
Oracle show grants on table
SQL
1 vote104 views2 answers
Mysql does sentance contain word
SQL
1 vote79 views1 answer
Oracle character set
SQL
0 vote135 views1 answer
Postgre query date
SQL
5 votes128 views2 answers
Postgres update with if condition query
SQL
11 votes116 views2 answers
Having clause in sql
SQL
0 vote103 views1 answer
Sql examples from your work
SQL
0 vote111 views1 answer
Mysql into outfile with headers
SQL
0 vote125 views1 answer
Create a plsql object
SQL