I love excel’s vlookup tool. it’s great for replacing stuff in one spreadsheet using key values and whatnot
UPDATE content_type_er_resources AS t
LEFT JOIN collections_resources AS e
ON e.id = t.field_er_resource_uid_value
SET t.field_er_resource_notes_value = e.res_notes
this is essentially the same thing in sql and it saved a bunch of time.
