axe312ger/gist:7200243

Created October 28, 2013 16:39

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

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

Download ZIP

Get all sql tables who contain a specific column.

Raw

gistfile1.sql

	SELECT DISTINCT TABLE_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE COLUMN_NAME IN ('COLUMN_NAME')
	AND TABLE_SCHEMA = 'TABLE_NAME';

Author

axe312ger commented Oct 28, 2013

This can be used to convert all language neutral content to the default language in drupal.

"Update TABLE_NAME SET language = 'en' WHERE language = 'und';"

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