Skip to content

Instantly share code, notes, and snippets.

@nsssim

nsssim/find_field_in_db

Last active August 29, 2015 14:14
Show Gist options
  • Save nsssim/f6e60d10b97471d81ac0 to your computer and use it in GitHub Desktop.
Save nsssim/f6e60d10b97471d81ac0 to your computer and use it in GitHub Desktop.
Download ZIP
mysql
Raw
find_field_in_db
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('xxxxx','yyyyyy')
AND TABLE_SCHEMA='database_name';
//will find xxxxx and yyyyyy in the databae
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment