How to replace by regular expression in database?

Question

MySQL

I want to translate all images on a wordpress site into webp format (I tried plugins, they are all buggy).
I converted the files, and I want to replace all jpg permissions with webp in the database, but it’s just that when I change .jpg to .webp, the site starts to fail, something else changes somewhere.
It is necessary to replace the type "*/uploads/*.jpg" with "*/uploads/*.webp" by mask, how can this be done? Quotes are also taken into account. What would change only the path to the files from the folder with the picture.

Answer 1

REGEXP_REPLACE()
isn't just a filter in the original request enough to cut off unnecessary replacements?