By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE tABLe wp_postmeta (meta_value varchar(100))
INSERT INTO wp_postmeta VALUEs ('https://example.com/wp-content/uplaods/2022/09/file.mp4')
,('https://example.com/wp-content/uplaods/2022/09/file.jpg'),('https://example.com/wp-content/uplaods/2022/09/file.png')
UPDATE wp_postmeta SET meta_value = replace(meta_value,'example.com','examplenew.com')
WHERE meta_value LIKE '%.mp4'
SELECT * FROM wp_postmeta
| meta_value |
|---|
| https://examplenew.com/wp-content/uplaods/2022/09/file.mp4 |
| https://example.com/wp-content/uplaods/2022/09/file.jpg |
| https://example.com/wp-content/uplaods/2022/09/file.png |