By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_REPLACE('This is some text with a url in it like https://www.example.com/profile/34251-username/ and https://www.exAMPLE.com/profile/95823-another-guy and such.','www.example.com\/profile\/([0-9]+)-','www.example.com/p$1/',1,0,'i') |
|---|
| This is some text with a url in it like https://www.example.com/p34251/username/ and https://www.example.com/p95823/another-guy and such. |