Converting/renaming gifs to clips while maintaining metadata?

[evil-p-anda]

Prior to support for 'clips' being added in image directories, I was running an ffmpeg script that would create a gif version of any mp4 files that were scraped into these directories, stored beside the original mp4 file.

The file names are exactly the same, with the ffmpeg script only adding .gif to the end of the file (ie. 'file1.mp4' > 'file1.mp4.gif').

I'm currently in the processing of trying to convert my system over to support clips and clean most gifs out my library, and am hoping to simply update these paths from .mp4.gif to .mp4, in order to maintain any metadata (tags etc) that has been previously linked to the images.

I was expecting this would be as simple as doing a search replace in the db, renaming the file paths etc - but this seems to break things (at least in my attempts of doing it) - any advice on how to approach?

For reference, the sql command I tried was:
UPDATE files SET basename = SUBSTR(basename, 1, LENGTH(basename) - 4) WHERE basename LIKE '%.mp4.gif';

Thanks in advance for any advice or help!