/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 vote193 views2 answers
Plsql regex match whole word
SQL
-1 vote190 views2 answers
Postgresql user permissions to database
SQL
1 vote206 views1 answer
Count mysql server db tables
SQL
0 vote185 views1 answer
Sql constarint
SQL
0 vote191 views1 answer
Longtext sql
SQL
0 vote215 views3 answers
How to assign custom id in mysql
SQL
-1 vote205 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote190 views1 answer
Create table Statement Syntax in SQL Server
SQL
3 votes181 views1 answer
Pl sql check if variable is empty
SQL
1 vote200 views1 answer
How to drop function in sql
SQL