title: ISSUE: Mysql converting Enum to Int
body: <p>I have a very simple rating system in my database where each rating is stored as an enum('1','-1').  To calculate the total I tried using this statement:</p>
  
  <pre><code>SELECT SUM(CONVERT(rating, SIGNED)) as value from table WHERE _id = 1
  </code></pre>
  
  <p>This works fine for the positive 1 but for some reason the -1 are parsed out to 2's. </p>
  
  <p>Can anyone help or offer incite?</p>
  
  <p>Or should I give up and just change the column to a SIGNED INT(1)?</p>