title: MySQL ORDER BY Date field which is not in date format
body: <p>I have a field containing dates in this format DD/MM/YYYY and I need to order the results DESC by this field, but it is saved as a VARCHAR and I cannot change this. Is there a workaround?</p>
  
  <p>There really is no way for me to change the field type so please don't say this is a bad way to do this as I already know. I just need to know if it is possible.</p>
  
  <p>Thanks for any help and advice in advance.</p>