帝国cms sql检则标题重复
<?php //检则标题重复 $sql=$empire->query("select id,filename from phome_ecms_news where classid=29 group by filename having(count(*))>2"); while($r=$empire->fetch($sql)){ echo $r[id].'<br />'; } ?>
查询重复标题
SELECT title, COUNT(title) FROM phome_ecms_news GROUP BY title HAVING COUNT(title) > 1
删除ID 较小的标题重复信息
DELETE t1 FROM phome_ecms_news t1 INNER JOIN phome_ecms_news t2 WHERE t1.keyid < t2.keyid AND t1.title = t2.title; .