between:select * from [tablename] where [日期] between '2013-01-01' and '2013-12-31' --查询字段[日期]在2013-01-01(含)至2013-12-31(含)之间 表tablename的记录。
