/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

6 votes293 views2 answers
Non relational database
SQL
1 vote187 views3 answers
Mariadb add foreign key
SQL
1 vote205 views2 answers
Oracle create synonym
SQL
5 votes192 views1 answer
Update sql user password
SQL
9 votes195 views3 answers
Mysql show table column full description
SQL
7 votes189 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote243 views1 answer
Sql select rows with different values in one column
SQL
0 vote200 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
16 votes216 views2 answers
Sql vs nosql
SQL
7 votes240 views1 answer
Xampp reset mysql
SQL