Skip to content

Instantly share code, notes, and snippets.

@alancoleman

alancoleman/filter_email_on_domain.sql

Created April 17, 2014 11:56
Show Gist options
  • Save alancoleman/10977444 to your computer and use it in GitHub Desktop.
Save alancoleman/10977444 to your computer and use it in GitHub Desktop.
Download ZIP
Filtering email addresses on domains
Raw
filter_email_on_domain.sql
AND (SUBSTRING_INDEX(SUBSTR(email, INSTR(email, '@') + 1),'.',1)) IN('yahoo', 'ymail', 'bt', 'rocketmail', 'msn', 'live', 'hotmail')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment