title: get numeric values from an ENUM column's issue
body: <p>to get numeric values from an ENUM column, can be using</p>
  
  <pre><code>mysql&gt; SELECT enum_col+0 FROM tbl_name;
  </code></pre>
  
  <p><a href="http://dev.mysql.com/doc/refman/5.5/en/enum.html" rel="nofollow">reference here</a></p>
  
  <p>But in my mysql5.5 console,this query return:</p>
  
  <pre><code>1.0000000000000000000000000000000
  </code></pre>
  
  <p>I want to get the a integer number <code>1</code></p>
  
  <p>I know I can use:</p>
  
  <pre><code>SELECT CONVERT(enum_col,UNSIGNED) FROM tbl_name;
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT CAST(enum_col AS UNSIGNED) FROM tbl_name;
  </code></pre>
  
  <p>I want to know why <code>enum_col+0</code> return a float,</p>
  
  <p>and any other way to get numeric values from an ENUM column?</p>