Return to Snippet

Revision: 60886
at November 16, 2012 00:50 by philsown


Initial Code
SELECT DISTINCT TABLE_NAME, COLUMN_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%column_name%'
AND TABLE_SCHEMA = 'database_name'

Initial URL


Initial Description
How to find a given column in a given database in MySQL

Initial Title
What MySQL Table Has What Column

Initial Tags
mysql, database, sql

Initial Language
MySQL