MySQL Email column validation | MySQL Email Validation

home-brew-mac

MySQL Email Validation

Simple code to remove duplicate email ids in MySQL and validation the email column also.

Show only Valid Email records

Example :-

SELECT distinct email,
email REGEXP '^[A-Za-z0-9._%\-+!#$&/=?^|~]+@[A-Za-z0-9.-]+[.][A-Za-z]+$' AS valid_email
FROM enquiry
having valid_email > 0

Packers and Movers in Dubai

Related posts

Leave a Comment