I had the question for the mysql date between select. In the mysql table, the field is varchar. The date range is '21-01-2013' and '31-01-2013', it can show the records, but the date range is '21-01-2013' and '20-02-2013', it cannot show the records. 

```
"SELECT * from away_from_office where (awaydatefrom between '21-01-2013' and '31-01-2013') ";

```