56,679
社区成员
发帖
与我相关
我的任务
分享
update yourTable a
set status=0
where exists(select id from yourTable where `content` =a.`content` and id<a.id);
update yourTable a
set status=0
where exists(select id from yourTable where `content` =a.`content` and id!=a.id);
update yourTable a inner join (select content from yourTable group by content having count(*)>1) b
on a.`content` = b.`content`
set a.status=0