帝國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; .

浙公網安備 33010602011771號