Posted By

philsown on 11/16/12

Tagged

Viewed 2954 times

Favorited by 1 user(s)

/ Published in: MySQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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

You need to login to view comments.