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