How to delete duplicate Posts in DLE?

[sSKKa]

i am running DLE site.... is there any query in SQL for "title" id so that i could delete duplicate records... I found this in google but its not working......

http://www.webtlk.com/2009/11/05/how-to-delete-duplicate-records-in-your-sql-database/

I am using this command

SELECT title, COUNT(*) FROM dle_post
Group BY Duplicate_dle_post  HAVING COUNT(*) > 1 

First code works great and it shows me the result but when i execute the second query it says unknown column find.

sSKKa Reviewed by sSKKa on 6th Oct 2011. How to delete duplicate Posts in DLE? i am running DLE site.... is there any query in SQL for "title" id so that i could delete duplicate records... I found this in google but its not working...... http://www.webtlk.com/2009/11/05/how-to-delete-duplicate-records-in-your-sql-database/I am using this command SELECT title, COUNT(*) FROM dle_post Group BY Duplicate_dle_post HAVING COUNT(*) > 1First code works great and it shows me the result but when i execute the second query it says unknown column find. Rating: 5

[soft2050]

Try this:

SELECT title, COUNT(*) FROM dle_post
Group BY id HAVING COUNT(*) > 1 

[sSKKa]

Try this:

SELECT title, COUNT(*) FROM dle_post
Group BY id HAVING COUNT(*) > 1 

not working mate

[sniffdog]

Moved. Please choose a more appropriate section next time.