select date from rvs where STR_TO_DATE(date, '%m/%d/%Y') between STR_TO_DATE('12/06/2007',
'%m/%d/%Y') and
STR_TO_DATE('01/07/2007',
'%m/%d/%Y')
select date from rvs where STR_TO_DATE(date, '%m/%d/%Y') between STR_TO_DATE('12/06/2007',
'%m/%d/%Y') and
STR_TO_DATE('01/07/2007',
'%m/%d/%Y')