/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

2 votes341 views1 answer
Search query in mysql
SQL
0 vote334 views1 answer
Ajax error exception handeling
SQL
0 vote338 views1 answer
Flexible search query delete table
SQL
2 votes331 views1 answer
Drop sequence
SQL
0 vote324 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote321 views1 answer
Python mysql executemany
SQL
0 vote330 views1 answer
Mysql sum with group by
SQL
0 vote323 views1 answer
Show table structure mysql console
SQL
2 votes331 views1 answer
Mysql change data type of column
SQL
1 vote314 views1 answer
Sql list all procedures
SQL