Query to Delete Duplicate Comments?
I had an issue with Disqus whereby it created duplicate comments on many posts, sometimes 4 duplicates of the same comment. I’ve been going through to try and manually remove these but we have more than 10K comments total and unfortunately, this happened haphazardly whereby it only happened to some of the posts. So…
does anyone know of a mysql query whereby I could detect and delete duplicate comments by searching for entries that match in terms of the comment itself or the author? The comment IDs are not duplicate (it created new comment IDs for each) so Im not sure how to do this in mysql (plus Im not very good at it :-)… Any help would be greatly appreciated. Thank you.
- The topic ‘Query to Delete Duplicate Comments?’ is closed to new replies.