Changing File Names in Database to match new file type.
I am trying to achieve a mass update on a specific category. What i'm doing is changing the entire contents of a category files from .wmv files to .flv in PP. I know i can do that in the database one by one but its going to be pretty strenuous exercise with over 500 videos. I have tried on one video and it works. The reason why I am doing this is because I want to still maintain the view count and comments that go with the old .wmv videos to carry over to the new .flv files in their place. From my simple testing, i guess the dimensions and file size do not affect this changes ---unless someone potentially thinks its a problem.
I am reaching out to anyone out there who know what lines i can execute in the database to make these changes en mass. I am keeping the same files names to make it easier.. All that is changing is just the extensions of the files. Thanks