Activity Stream
48,167 MEMBERS
6871 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Results 1 to 2 of 2
  1.     
    #1
    Member

    Default (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:
    Code: 
    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 . (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

  2.   Sponsored Links

  3.     
    #2
    Member

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Duplicate content checker?
    By Suhel in forum Webmaster Discussion
    Replies: 6
    Last Post: 5th Jun 2012, 08:58 AM
  2. How to Remove Duplicate Content Webmaster tool?
    By nasavsisro in forum Webmaster Discussion
    Replies: 1
    Last Post: 5th Jun 2012, 04:00 AM
  3. IPB help Duplicate Content (www redirect)
    By Doom in forum IP.Board
    Replies: 2
    Last Post: 30th Apr 2012, 01:30 PM
  4. Duplicate Content
    By chemicalx in forum Webmaster Discussion
    Replies: 11
    Last Post: 5th Dec 2011, 10:03 AM
  5. [HELP] I Need duplicate post remove plugin for vb
    By gfxguru in forum Webmaster Resources
    Replies: 4
    Last Post: 25th Jul 2010, 12:52 PM

Tags for this Thread

BE SOCIAL