Hi everyone,

Here's my situation: I have several CDs ripped as FLAC and MP3 in my Amarok collection, stored in the same directory, with identical filenames (except extensions, obviously).  I've been labouring over how I can copy the statistics from my collection.db for the MP3 files over to the newly imported FLAC files... and I can't figure out how!

The problem I'm facing is that I don't know how to SELECT the entries in the uniqueid table that have *almost* identical urls.  I can count how many DISTINCT filenames there are (based on just the first two characters (##-Artist-Track.ext) but I don't know how to SELECT the entries that have more than one with the same dir and same first two chars of the filename.  Could anyone help me out with this please?

After that I'd like to delete the MP3s' entries from the database so I'll just be left with the FLAC entries.  I would have just edited the urls and replaced "MP3" with "FLAC" but it's not that easy now that we have uniqueids!

All help is greatly appreciated!!
-Aaron