What MySQL Table Has What Column - MySQL Snipplr Social Repository

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