/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

13 votes426 views3 answers
Mysqldump structure only
SQL
0 vote360 views1 answer
Find invalid datetime field
SQL
0 vote393 views1 answer
Query builder doctrien return sql
SQL
11 votes387 views6 answers
Mysql else if
SQL
0 vote388 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote352 views1 answer
Set column width in sqlplus
SQL
5 votes387 views2 answers
Postgresql insert select
SQL
1 vote384 views1 answer
Setval pgsql
SQL
12 votes365 views4 answers
Import mysql database command line linux
SQL
0 vote369 views1 answer
Hour differeence in mysql
SQL