title: Wrong date from mysql in order by
body: <p>Greetings hope to get some help from you here as i been searching high and low for this.</p>
  
  <p>This query works but its not the results i wanted more correctly not the right date format i want it in.</p>
  
  <pre><code>SELECT DISTINCT colum FROM table WHERE colum IS NOT NULL
  </code></pre>
  
  <p>This query gives me the dates</p>
  
  <pre><code>01.04.13
  02.04.13
  03.04.13
  30.03.13
  31.03.13
  </code></pre>
  
  <p>I wanted it to show latest date.</p>
  
  <p>This info is posted in colum that stores the info as text. It is posted in the following format</p>
  
  <pre><code>dd.mm.yy
  </code></pre>
  
  <p>I wanted it then to show me the results as in
  03.04.13 since this is todays date. i know i can limit it to 1 but still it will show the wrong date.</p>
  
  <p>Thank you again for all help so far</p>