/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

11 votes135 views6 answers
Distinct sql
SQL
2 votes139 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote136 views1 answer
Delete ids between sql
SQL
2 votes137 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote131 views1 answer
Sql quary intervewi question
SQL
0 vote135 views1 answer
Sql alter table order by
SQL
0 vote142 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote154 views1 answer
Mysql insert into select transaction c#
SQL
1 vote127 views2 answers
Sql select only first occurrence
SQL
0 vote137 views1 answer
Alter table engine mysql
SQL