Was curious what Flamerobin is, got the following url:
How to find duplicate records?[
^]
Quote:
You might want to add an UNIQUE index on some table fields (for example field ID) but need to find and remove duplicates first. Here's a query to find them:
select id, count(*)
from t1
group by id
having count(*) > 1;