checkedresponsive[@]gmail.com

Menu

MySQL Email column validation | MySQL Email Validation

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

Leave a Reply

Your email address will not be published. Required fields are marked *