/*将EMAIL字段值没有包含@的更新为[email protected]*/ UPDATE TABLENAME SET EMAIL = '[email protected]' WHERE EMAIL NOT LIKE '%@%'/*删除USER = EMAIL记录*/ DELETE FROM TABLENAME WHERE [USER] = [EMAIL]
UPDATE [Table] SET [Field]='[email protected]' WHERE CHARINDEX('@',[Field])=0 DELETE FROM [Table] WHERE LEN(MD5)>32
update tb set email='[email protected]' where email not like '%@%' --清空md5列非正常数据 update tb set md5='' where len(md5)>32 --删除md5列非正常数据 delete tb where len(md5)>32
UPDATE TABLENAME SET
EMAIL = '[email protected]'
WHERE EMAIL NOT LIKE '%@%'/*删除USER = EMAIL记录*/
DELETE FROM TABLENAME WHERE [USER] = [EMAIL]
DELETE FROM [Table] WHERE LEN(MD5)>32
update tb set email='[email protected]' where email not like '%@%'
--清空md5列非正常数据
update tb set md5='' where len(md5)>32
--删除md5列非正常数据
delete tb where len(md5)>32