http://lmgtfy.com/?q=mysql+remove+duplicate+rows
deliteblogger Reviewed by deliteblogger on . (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