• My website has about 200k posts so naturally there are bound to be some duplicates. I’ve found this bit of mySQL:

    [code]
    DELETE bad_rows.*
    from wp_posts as bad_rows
    inner join (
    select post_title, MIN(id) as min_id
    from wp_posts
    group by post_title
    having count(*) > 1
    ) as good_rows on good_rows.post_title = bad_rows.post_title
    and good_rows.min_id bad_rows.id
    [/code]

    Only problem is it deletes posts with like titles. This won’t do. Any idea how to modify this so it only deletes duplicate posts in each category?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘Delete Duplicate Posts From Like Category’ is closed to new replies.