MySQL 8.0

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