数据准备
drop table Users;
Create table If Not Exists Users (user_id int, name varchar(30), mail varchar(50));
Truncate table Users;
insert into Users (user_id, name, mail) values ('1', 'Winston', 'winston@leetcode.com');
insert into Users (user_id, name, mail) values ('2', 'Jonathan', 'jonathanisgreat');
insert into Users (user_id, name, mail) values ('3', 'Annabelle', 'bella-@leetcode.com');
insert into Users (user_id, name, mail) values ('4', 'Sally', 'sally.come@leetcode.com');
insert into Users (user_id, name, mail) values ('5', 'Marwan', 'quarz#2020@leetcode.com');
insert into Users (user_id, name, mail) values ('6', 'David', 'david69@gmail.com');
insert into Users (user_id, name, mail) values ('7', 'Shapiro', '.shapo@leetcode.com');
输入
![在这里插入图片描述](https://img-blog.csdnimg.cn/c095c0faa4154aa89c5040ea1093151c.png)
分析
输出
select *
from Users
where mail regexp '^[a-zA-Z][a-zA-z0-9\_\.\-]*@leetcode\.com$';
![在这里插入图片描述](https://img-blog.csdnimg.cn/5acce5f9b32f41f4aa9041bda82f5f77.png)