Author’s Note:
Alternatively, you could use this wonderful plugin to aide you in correcting the url’s in the guid and meta_value fields.
Search and Replace:
http://ww.wp.xz.cn/extend/plugins/search-and-replace/
Author’s Note:
This will not correct URL’s that already exist in the database. You will either have to do that manually, or remove the database entry and re-import.
