SQL patch to change image file extension from .jpg to .webp

[schoolboy]

I have converted all my images to .webp file format, from .jpg .
All image file NAMES remain the same - only the extension is now .webp
I'd like a quick SQL patch to do a global change of the database references of images, where the filename remains the same, but the extension is changed from .jpg to .webp

[lat9]

Erm, you answered this (essentially) back in 2011: https://www.zen-cart.com/showthread....rom-JPG-to-jpg.

[schoolboy]

Erm, you answered this (essentially) back in 2011: https://www.zen-cart.com/showthread....rom-JPG-to-jpg.

Only Cindy is this observant! 11 years later (with advancing age) one becomes rather forgetful. Thanks for pointing me to my own solution.
BTW, I'll be getting in touch via email in a week or two regarding my new ZC site (on version 1.5.7d)... I may need some help and advice on a few things.