title: MySql select Mix and Max year
body: <p>Hi guys I am developing a php and mysql application. I want to select Min and Max from year. It should show correct year like below:</p>
  
  <pre><code>Min = 1998
  Max = 2014
  </code></pre>
  
  <p>My table structure like below</p>
  
  <h2>Table: Students</h2>
  
  <pre><code>year varchar(32)    utf8_unicode_ci 
  -------------------------------
  06-04-2012
  02-05-2014
  19-04-1999
  05-05-2014
  06-04-1998
  </code></pre>
  
  <p>I try to use MySql Min and Max but not working well.</p>
  
  <pre><code>SELECT MIN(`year`) AS Year FROM `Students`
  
  SELECT Max(`year`) AS Year FROM `Students`
  </code></pre>
  
  <p>Please help me with this issue.</p>