title: HOW select min from cast varchar to int in mysql
body: <p>How to convert varchar into double value in mysql</p>
  
  <p>See, i have table column in varchar but it has only numbers. In that i want to select min max of the value.</p>
  
  <p>Please check the below query, in which I'm getting a syntax error.</p>
  
  <pre><code>select 
      MAX(CAST(ch1 as INT)) as max_ch1,
      MIN(CAST(ch1 as INT)) as min_ch1 
  from t9;
  </code></pre>
  
  <p>Please refer to below <a href="http://sqlfiddle.com/#!2/352f58/1" rel="nofollow">sqlfiddle</a></p>