All attachments are stored in the
wp_posts table with
post_type set to "attachment." The GUID for each attachment is set to the original URL when it was inserted - don't change this! GUIDs are meant to be used for identification and shouldn't be changed, they aren't used for permalinks.
The URLs you want to change are actually in the
wp_post_meta table. Whenever you create a new publication in WordPress, you add an absolute URI reference to a custom post type. This reference is stored in a custom meta field for that post - the field is called
So just look in your
wp_post_meta table for any entry with a key of
wpa_upload_doc and change the value to match the new URL.