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; ELSE SELECT * FROM product_types; END CASE;