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