Please Help

I'm looking for ways to insert full path image links in a MySQL database. Currently we have a few hundred html fragments for our site that contain relative links (eg. data/reviews/images/blah.jpg), and with a new system we cannot use these so I need to find some way of going in inserting our domain before these paths hopefully in a php or bash script - I plan on dumping the database and working off of the text file since I don't want to screw up a live server.

Anyone have any suggestions? I'm not very good with pattern matching/replacing and especially with file handlers.