Duplicate entires be gone!

Wednesday, December 12th, 2007

I’ve got a bug in one of my scripts somewhere that’s saving multiple entries for video files in mythtv’s videometadata table. Here’s a quick hacky SQL query to find them:

SELECT intid, filename, coverfile
FROM videometadata
WHERE filename IN
  (SELECT filename FROM
    (SELECT filename, COUNT(*) AS ttl FROM videometadata
     GROUP BY filename HAVING ttl > 1
    ) AS tmpfoo
  ) ORDER BY filename

Posted in Uncategorized | No Comments »