aabril/find_column_name.sql

Created February 2, 2012 12:57

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aabril/1723344.js"></script>
Save aabril/1723344 to your computer and use it in GitHub Desktop.

Download ZIP

Find on a mysql database, a column named column_name

Raw

find_column_name.sql

	SELECT TABLE_NAME, COLUMN_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE column_name LIKE '%column_name%';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment