title: How do I update a fields in table with strings randomly selected from a known list?
body: <p>I have a table named "buildings" that contains a varchar(50) field named "use".  The table already has several thousand records, however the "use" values are all null.  I would like to update these this table with randomly chosen values from a list of strings <em>(e.g., warehouse, office, market, retail, workshop)</em>. I would also like to leave some of these null to emulate real world usage.</p>
  
  <p>How can I update a field in a table with strings randomly selected from a known list?</p>