[wp-hackers] Change file attachment URL - db field

[Duncan O'Neill]

Hi all,

I have a situation where I converted from one shopping cart
to another.

As a result, the attachment URLs ( which I can see via the
media library via the File URL field) need changing. There
are more than 150 products, so I don't want to do it manually
if I can helpit. As a trial run, I tried changing the GUID of an
attachment in the attachment's post entry in the database.
But this has no effect, the File URL in the media library for
that item has stayed the same.

So, where in the database is the attachment's URL held?

Alternatively, is there an easier way to bulk change
File URLs for attachment ( featured image ) media?

thanks in advance,

-- 
Duncan O'Neill
http://urbanlegendweb.co.nz/
mob:+64 27 385 8086
skype: maxwell_s