Page 24: UPDATE/SET/CASE

UPDATE movie_table
SET category = 'drama' where drama = 'T';

UPDATE movie_table
SET category = 
CASE 
  WHEN drama = 'T' THEN 'drama'
  WHEN comedy = 'T' THEN 'comedy'
  WHEN action = 'T' THEN 'action'
  WHEN gore = 'T' THEN 'horror'
  WHEN scifi = 'T' THEN 'scifi'
  WHEN for_kids = 'T' THEN 'family'
  WHEN cartoon = 'T' THEN 'family'
ELSE 'misc'
END;