mysql查询近7天，半年，一年数据

• 近7天数据

SELECT * from oms_order_item_comment 
     where comment_time between date_sub(now(),interval 1 week) and now()  -- 七天

• 半年数据

SELECT * from oms_order_item_comment 
     where comment_time between date_sub(now(),interval 6 month) and now()  -- 半年

• 一年数据

SELECT * from oms_order_item_comment 
     where comment_time between date_sub(now(),interval 1 year) and now()  -- 一年