/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 vote205 views4 answers
Mysql select bottom 10 rows
SQL
0 vote201 views1 answer
Mysql 1 hour ago
SQL
37 votes195 views3 answers
Duplicate records in sql
SQL
0 vote342 views1 answer
Dublicate row sql
SQL
4 votes207 views2 answers
Mysql show indexes on table
SQL
0 vote210 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote220 views1 answer
Limit in access query
SQL
0 vote171 views1 answer
Mysql sleep connections
SQL
0 vote188 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
1 vote196 views1 answer
Mysql find tables with column name
SQL