By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_REPLACE(txt, 'https://[^ ]+ |$', LOWER(REGEXP_SUBSTR(txt, 'https://[^ ]+ |$')), 1, 1) |
|---|
| Lorem ipsum text https://www.website.com/products/name-of-product1.html text text Dolor Sit Amet |
| LOREM Other ipsum text https://www.website.com/products/name-of-product2.html text text DOLOR Sit Amet |