how can I loop to update record in sql server

how can I loop to update record in sql server

I have database records to store page urls but we have problem in
deployment the developer using localhost to store page filed in database
because of that we end up with
http://localhost:8080/wow/page1.aspx
http://localhost:8080/wow/page2.aspx
http://localhost:8080/wow/page3.aspx
just wondering can i write Tsql to loop throw record to remove the
localhost from url and updating the new url