Thursday, February 14, 2013

MySQL Find Column Name in any Table in Entire Database

SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE '%Name%';



Just change the change of your column name, you can able to find the column name, and table name from the whole database.

No comments: