Skip to content

Instantly share code, notes, and snippets.

@noudadrichem

noudadrichem/get-domain-from-email.sql

Created May 14, 2019 15:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save noudadrichem/ea2b037ae8c0e653eea920954c972abb to your computer and use it in GitHub Desktop.
Save noudadrichem/ea2b037ae8c0e653eea920954c972abb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get-domain-from-email.sql
SELECT [email_column], SUBSTRING([email_column], POSITION('@' IN [email_column]) + 1) AS domain_name
FROM [table]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment