Hey , this might really be better asked in a mysql forum i realize but was hoping someone here could help.

My amarok collection shows duplicate entries for several entries and I'd like to deleted the duplicate entries.
Aparently the database scanner in amarok is not removing them for me when it checks for changes.
So how can you delete duplicate entries from the mysql database?

MySQL client version: 5.0.32
Amarok 1.4.7