(SQL) How can I remove duplicate content from DB?

[hatem20]

Hey,

I got over 2k duplicate content in my site SQL database, I need a quick solution to remove them and just keep the older/original post.

I used this command to sort the duplicate content according to titles:

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

here's the result:


As you can see, below each title there are 2-4 "copies" - I want to keep one and remove the rest. Is that possible?

I look forward to reading your thoughts.
Thanks in advance.

hatem20 Reviewed by hatem20 on 26th Oct 2011. (SQL) How can I remove duplicate content from DB? Hey, I got over 2k duplicate content in my site SQL database, I need a quick solution to remove them and just keep the older/original post. I used this command to sort the duplicate content according to titles: SELECT title, COUNT(*) FROM dle_post Group BY `title` HAVING COUNT(*) > 1here's the result: http://i27.lulzimg.com/c173a98425.jpg As you can see, below each title there are 2-4 "copies" - I want to keep one and remove the rest. Is that possible? :D Rating: 5

[deliteblogger]

http://lmgtfy.com/?q=mysql+remove+duplicate+rows