/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 vote242 views1 answer
Oracle running queries
SQL
7 votes228 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote244 views1 answer
Query builder doctrien return sql
SQL
0 vote217 views1 answer
Microsoft word insert sql code
SQL
0 vote269 views1 answer
FIND most frequent word in sql server
SQL
0 vote231 views2 answers
Sql last updated
SQL
0 vote258 views1 answer
Mysql record group by created date count
SQL
2 votes227 views1 answer
Postgresql drop primary key constraint
SQL
1 vote222 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote250 views1 answer
Firebase sql
SQL