Email address Validation in MySql using RLIKE
MySql supports regular expressions in RLIKE operator.
Here is the regular expression for checking a valid email address:
email RLIKEÂ ‘^[-0-9a-z_\\.]+@[-0-9a-z_\\.]+\\.[a-z]{2,3}$’
Archive for SQL
MySql supports regular expressions in RLIKE operator.
Here is the regular expression for checking a valid email address:
email RLIKEÂ ‘^[-0-9a-z_\\.]+@[-0-9a-z_\\.]+\\.[a-z]{2,3}$’