[BetterRed]

@mike_bike_kite - I've done something similar as yourself - interrogated the database to identify potential 'problems', I used the output to create a .csv containing author and title

Then I pushed the csv into the Import List plugin, amongst other things the plugin can creating a Reading List (another plug in). So I ended up with Reading Lists like SwapAuthorTitle, RubbishInTitle etc.

Then I did the changes using standard Calibre facilities - many of which can be done in bulk - eg swap author & title. This addresses the issues Adoby & itimpi have raised - of ensuring the database & folders remain in synch

I find this technique quite useful - I do something similar with the results from Windows and Spotlight content searches

BR