Posted By

philsown on 11/16/12

Tagged

Viewed 1010 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'

Comment:

You need to login to post a comment.