Delete Duplicate WordPress Comments

24 June 2013 on Wordpress.

I ran into a situation recently where all of the comments on a blog I was working on got doubled up, so I had to figure out a way to get rid of the extra ones. I read some solutions involving using two MySQL tables but I was hoping to avoid dealing with all that.

I ended up writing this script that basically goes through each comment and checks if another comment with the same content exists on the same post, and if so deletes it. It’s pretty simple I think and worked like a charm for me so I thought I’d share it here. Remember to always backup your database before running any kind of fixes like this, just in case.


Next

MidiWriterJS - A JavaScript Library for Creating Expressive MIDI Files

Being a musician and a programmer I've always been interested in the MIDI file format and the possible web applications that could leverage it. When I first started programming I really wanted to do something with MIDI so I looked up the spec for the MIDI file format but was very intimidated by the details, like woah.