<?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; .
