用的什么数据库?如果是oracle的话可以试试这个delete from user where user_id in (SELECT user_id FROM user WHERE REGEXP_LIKE(email, '\w+@\w+(\.\w+)+'))
delete from [user] where [Address 电子邮箱] like '%@%'
“Address 电子邮箱” 是指什么呢? 如果你的邮箱地址是存在 user表的 email字段,并且要求email格式是 [email protected] 那么这样查可以查到部分错误的email地址: select * from user where email not like '%@%.%' 删除就简单了,按照上面语句删除就好了: delete from user where email not like '%@%.%'
‘Address 电子邮箱’ 是什么意思啊?我不知道你具体的筛选条件是什么,下面这个是只保留[email protected]格式的,其他都删除
delete from user where email not like '???@???.???'
--先查询看看是不是都符合再进行删除操作
select from [user] where email not like '%@___.___'
delete from [user] where email not like '%@___.___'
上面的都不行。
FROM user WHERE REGEXP_LIKE(email, '\w+@\w+(\.\w+)+'))
如果你的邮箱地址是存在 user表的 email字段,并且要求email格式是 [email protected]
那么这样查可以查到部分错误的email地址:
select * from user where email not like '%@%.%'
删除就简单了,按照上面语句删除就好了:
delete from user where email not like '%@%.%'