title: How do I update the members of a MySQL SET Type?
body: <p>I have a table of values, with one of the columns being of type <a href="http://dev.mysql.com/doc/refman/4.1/en/set.html" rel="noreferrer">SET</a>.</p>
  
  <p>If it currently has the members ('a', 'b', 'c', 'd'), how do I add 'e' to the possible values?</p>
  
  <p>I realize that using a SET type is a little strange, and I'm unclear why one would use it instead of a foreign key to another table with the values of the set, but I didn't design the database in question, and can't change it that much.</p>
  
  <p>Thanks for your help!</p>
  
  <p><strong>UPDATE:</strong> I want to update the SET type for <em>all</em> rows, not just one, if that helps.</p>