A drupal 6 content_field_video table holds serialized data with URLs pointing to the old site location -
sites/default/files/thumb.png. Moving to the otherwise amazing Aegir-based omega8 hosting platform, we moved to a new files directory,
sites/MYSITE.COM/files/thumb.png, so we need to convert to URLs to a new scheme. Most of the URLs are corrected by the omega8 import process, but video thumbnails are hardcoded.
What's the easiest way to do it?