between and 时间查询

select * from betweenAndTest where birthDay= str_to_date(20120401,'%Y%m%d');

 

select * from betweenAndTest where score between 80 and 100 AND
age BETWEEN 5 AND 20;

 

select * from project_jyouhou where STARTDAY between 20120101 and 20121231
and ENDDAY between 20120101 and 20121231