我怎样才能过滤到日期范围Select*fromXXXwheredatebetweenDATE1ANDDATE2ORBetweenDATE3ANDDATE4(从作为答案发布的更新中复制)这是我的条件WHERE(items_count!='0')AND(main_table.is_active='1')AND(main_table.store_idIN('0','1'))AND(main_table.updated_atBETWEEN'2011-03-0416:52:19'AND'2011-03-0516:52:19')OR(main_table.updated_atBETWEEN'201