注册mysql确认邮件_验证Mysql中的电子邮件地址

最新推荐文章于 2021-03-26 08:40:05 发布

weixin_39722070

最新推荐文章于 2021-03-26 08:40:05 发布

阅读量736

点赞数

文章标签：注册mysql确认邮件

本文链接：https://blog.csdn.net/weixin_39722070/article/details/113720481

版权

此查询创建一个在一个表中捕获不良电子邮件地址格式的mysql视图。所以如果一行插入有rtrrg.com作为一个电子邮件，它将被记录在视图中。我的问题是，如何使视图跟踪多个表。第二张桌子。

SQL

CREATE VIEW `invalid_emails` AS

select `table_with_email_column`.`email` AS `invalidemail`

from `table_with_email_column`

where ((locate(_latin1'', ltrim(rtrim(`table_with_email_column`.`email`))) <> 0)

or (left(ltrim(`table_with_email_column`.`email`), 1) = _latin1'@')

or (right(rtrim(`table_with_email_column`.`email`), 1) = _latin1'.')

or ((locate(_latin1'.', `table_with_email_column`.`email`,locate(_latin1'@', `table_with_email_column`.`email`)) - locate(_latin1'@', `table_with_email_column`.`email`)) <= 1)

or ((length(ltrim(rtrim(`table_with_email_column`.`email`))) - length(replace(ltrim(rtrim(`table_with_email_column`.`email`)), _latin1'@', _latin1''))) <> 1)

or (locate(_latin1'.', reverse(ltrim(rtrim(`table_with_email_column`.`email`)))) < 3)

or (locate(_latin1'.@', `table_with_email_column`.`email`) <> 0)

or (locate(_latin1'..', `table_with_email_column`.`email`) <> 0));