/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

-1 vote93 views2 answers
How to select the lowest values from table per client sql
SQL
6 votes156 views2 answers
Database url postgres
SQL
0 vote97 views1 answer
Backup a table in sql
SQL
3 votes94 views2 answers
Postgres download
SQL
4 votes97 views1 answer
Mysql set max connections
SQL
1 vote290 views1 answer
Postgres upgrade to superuser
SQL
0 vote102 views2 answers
Plsql regex match whole word
SQL
1 vote103 views1 answer
Psql datetime grather than
SQL
9 votes102 views3 answers
Sql delete where in
SQL
0 vote122 views2 answers
Mysql insert into multiple tables
SQL