How to delete duplicate entries in mysql

This removes duplicates in place, without making a new table


ALTER IGNORE TABLE foobar ADD UNIQUE (title, SID)

I orginally found this here on stackoverflow.