/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 vote290 views1 answer
Query string starts with vowels
SQL
0 vote279 views2 answers
Close external port 3306 with iptables
SQL
1 vote270 views1 answer
Postgres count string length
SQL
2 votes269 views1 answer
Create table with primary key
SQL
15 votes271 views3 answers
Create table with primary key auto increment in sql
SQL
6 votes267 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote278 views1 answer
Sql count total by foreign key
SQL
7 votes289 views3 answers
Sql server reset auto increment
SQL
0 vote274 views2 answers
Sql join on comma separated field
SQL
3 votes267 views1 answer
Mysql load sql from file
SQL