UPDATE opportunities SET product_id = CASE opportunities.datum_product WHEN 'SWS' THEN 1, WHEN 'WSF' THEN 2, WHEN 'WSF (adjustable)' THEN 3, WHEN 'SMT' THEN 4, WHEN 'PFJ' THEN 5, WHEN '5DX' THEN 6, WHEN 'Assembly Tooling' THEN 7, WHEN 'Tooling' THEN 8, WHEN 'Print Support Tooling' THEN 9, WHEN 'Conformal Coat Fixture' THEN 10, WHEN 'Flying Probe Fixture' THEN 11, WHEN 'Inspection Template' THEN 12, WHEN 'Pneumatic Press Tooling' THEN 13, WHEN 'Pneumatic Press Small' THEN 14, WHEN 'Pneumatic Press Large' THEN 15, WHEN 'Mods' THEN 16, WHEN 'Other' THEN 17 END CASE;