How can I Automate a Mass Change to URL's that are linked in the Comment and Description Fields

[Sean Edler]

My Company changed the Sharepoint location and all of our Files were moved to this new sharepoint. 

Our Jira instance references all the old URLs which no longer exist. What is the best way to 

1) Find all the links in Comments and Descriptions? (Sql?) (Export XML?)

2) Replace all those links with the new Link? ( I can make an array if I have the old links)

3) Last time we did this, we used the Export XML option, and we re-imported with all the changes. The Problem is that the Boards were all screwed up upon re-importing and we had to run additional scripts against the API to fix all those errors. 

Any one have any experience in this type of change?