toledorobia/validate_email.sql

Last active August 14, 2023 04:45

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/toledorobia/25ef67b3793b2edac3eb.js"></script>
Save toledorobia/25ef67b3793b2edac3eb to your computer and use it in GitHub Desktop.

Download ZIP

MySQL - Validate email

Raw

validate_email.sql

	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}$'

thureos commented Jun 5, 2019

Saludos!

Gracias por este gist, pero creo que ya no soporta los nuevos TLD.

Que te parece este? Solo cambie la longitud del ultimo a +

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]+$'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment