I have a table that contains a number of rows with columns containing a URL. The URL is of the form:
http://one.example1.com:9999/dotFile.com
I would like to replace all matches in that column with http://example2.com/dotFile.com
while retaining everything after :9999. I have found some documentation on regexp_matches and regexp_replace, but I can't quite wrap my head around it.