I'm interested in search and replacing part of a Link's URL. A bunch of Links are broken because the Link owner changed their URLs without providing forwarders. Anyways, I've search the forums and I've tracked down a few examples of how this is supposed to be done. However, I want to confirm this before I go ahead and make the changes to the database. Here is what I want to do,
http://www.example.ca/boardwiseii/Document.asp?DID=815
to
http://sso.example.ca/e-Library/Document.asp?DID=815
so following the instructions found in the forums, would this work?
http://www.example.ca/boardwiseii/Document.asp?DID=815
to
http://sso.example.ca/e-Library/Document.asp?DID=815
so following the instructions found in the forums, would this work?
Code:
UPDATE Links SET URL = REPLACE(URL, 'http://www.example.ca/boardwiseii/Document.asp', 'http://sso.example.ca/e-Library/Document.asp')Code: