Blogger Import: Images still point to Blogger site

Hi,

and thanks for reading my first WP forum question!

Ive imported my old Blogger stuff into my new WP site however the images for these older posts are still loaded from Blogger.

I have all the images locally in a known location and ideally I would like to do a search and replace in the database retaining the image filename but replacing all paths that point to Blogger.

Calling all Sql Kings, Queens and mages of regular expression.

Thanks
howlonghowfar.org