Editing Mass Image Sources

I’ve recently imported an old blog database into my site, but after loading the import file with download attachments function, and uploading all the image files into the same hosting, some images still show image source as the old site. But some are working fine. It’s almost 50/50

Is there a way to mass fix the broken images with changing the source site? ie instead of http://www.site1.com/upload/imagename.jpg it will be http://www.site2.com/upload/imagename.jpg