Skip to content

Instantly share code, notes, and snippets.

@KensoDev
Created December 16, 2011 13:04
Show Gist options
  • Select an option

  • Save KensoDev/1485969 to your computer and use it in GitHub Desktop.

Select an option

Save KensoDev/1485969 to your computer and use it in GitHub Desktop.
Search for a column in all tables of the database
SELECT * FROM information_schema.`COLUMNS` C WHERE TABLE_SCHEMA = 'your_db_name' and column_name = 'your_column_name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment