/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 vote152 views1 answer
Create or replace view postgress
SQL
2 votes153 views3 answers
Sql truncate table
SQL
4 votes180 views3 answers
Postgres drop all tables
SQL
0 vote151 views2 answers
2nd max salary query in sql
SQL
0 vote161 views1 answer
USING THE NOT CONDITION IN SQL
SQL
1 vote286 views1 answer
Sql check roles
SQL
11 votes181 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
13 votes173 views3 answers
List all the tables in sql
SQL
0 vote140 views1 answer
Oracle search columns in schema
SQL
17 votes162 views5 answers
Order by sql
SQL