title: varchar date time comparison issue
body: <p>I have a legacy table which has a varchar column represent date, format is <code>MM/DD/YYYY</code> (e.g. 01/08/2015). It is not convenient to perform data range selection since it is a varchar (when I use &lt; or > kinds comparison, it goes to varchar/string comparison, which have different results from date comparision). </p>
  
  <p>For example, I want to select only rows which dates are between 01/08/2015 and 01/10/2015. Any smart solution is appreciated, and I cannot change the data type of varchar to date in my existing table.</p>
  
  <p>I am using MySQL Workbench/MySQL.</p>