UPDATE photos
   SET caption = REPLACE(caption,'"','\'')