Library Question. Removal of Movies data only.

[clackerdacker]

Hi,

Is there a way, or does anyone have an SQL script I can have, to remove Movie only data from the library whilst leaving the TV show data untouched?

The reason I ask is I update my movies from .NFO files weekly now to keep all the data up to date but the only way I can get my existing movies to refresh is to delete the library entirely beforehand. This is obviously a major pain in the arse.

So, any ideas, tips or whatever?

TIA

[althekiller]

Set the content on your movies dir to "none" and answer yes when it asks you to remove the items from the db.

[clackerdacker]

Of course! Didn't even think of that. Many thanks.