Skip to content

Instantly share code, notes, and snippets.

@toledorobia

toledorobia/validate_email.sql

Last active August 14, 2023 04:45
Show Gist options
  • Save toledorobia/25ef67b3793b2edac3eb to your computer and use it in GitHub Desktop.
Save toledorobia/25ef67b3793b2edac3eb to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Jonathan Toledo Orobia renamed this gist Jan 5, 2018. 1 changed file with 0 additions and 0 deletions.
    0 main.sql → validate_email.sql
    View file
    File renamed without changes.
  2. Jonathan Toledo Orobia renamed this gist Jan 5, 2018. 1 changed file with 0 additions and 0 deletions.
    0 validate_email.sql → main.sql
    View file
    File renamed without changes.
  3. Jonathan Toledo Orobia revised this gist Jan 5, 2018. No changes.
  4. toledorobia revised this gist Dec 10, 2015. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion validate_email.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,3 @@
    SELECT *
    FROM user
    WHERE email NOT REGEXP '^[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]@[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]\.[a-zA-Z]{2,4}$'
    WHERE email NOT REGEXP '^[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9_\-]@[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]\.[a-zA-Z]{2,4}$'
  5. toledorobia renamed this gist Dec 10, 2015. 1 changed file with 0 additions and 0 deletions.
    0 script.sql → validate_email.sql
    View file
    File renamed without changes.
  6. toledorobia created this gist Dec 10, 2015.
    3 changes: 3 additions & 0 deletions script.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    SELECT *
    FROM user
    WHERE email NOT REGEXP '^[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]@[a-zA-Z0-9][a-zA-Z0-9._-]*[a-zA-Z0-9]\.[a-zA-Z]{2,4}$'