title: sorting - Order By date ASC
body: <p>I have "date" column in mysql saving the dates with this format<br>
  17-09-2014 (DD-MM-YYYY)</p>
  
  <p>I need to sort them ascending, so I used this command:  </p>
  
  <pre><code>SELECT * FROM table ORDER BY date ASC
  </code></pre>
  
  <p>But I found this result:  </p>
  
  <pre><code>17-09-2014
  18-09-2015
  19-09-2014
  </code></pre>
  
  <p>It should be:  </p>
  
  <pre><code>17-09-2014
  19-09-2014
  18-09-2015
  </code></pre>
  
  <p>It sorts the day only ASC not the full date</p>