Skip to content

Instantly share code, notes, and snippets.

@bahadirdogru

bahadirdogru/sql-check-valid-email.sql

Last active December 29, 2020 13:50
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 bahadirdogru/bece9d334bbded41f453bd061fe6f193 to your computer and use it in GitHub Desktop.
Save bahadirdogru/bece9d334bbded41f453bd061fe6f193 to your computer and use it in GitHub Desktop.
Download ZIP
Sql Email Verification
Raw
sql-check-valid-email.sql
select * from emails
where
and EMAIL LIKE '%_@%_.__%'
and EMAIL like '[a-z,0-9,_,-]%@[a-z,0-9,_,-]%.[a-z][a-z]%'
and EMAIL not like '%[;,üğçö<>:*/\{}[]()&%^!~¨$#£½|"é€æ?=]%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment