select
*
from courseware_visit_history_info v
where v.COURSEWARE_VISIT_ID='000bf820b2574f8dabdc2bb1c7c63241'
and v.VISIT_TIME BETWEEN date_sub(NOW(),interval 7 day) and NOW()
konglxblog 2018-04-06 20:55 原文
select
*
from courseware_visit_history_info v
where v.COURSEWARE_VISIT_ID='000bf820b2574f8dabdc2bb1c7c63241'
and v.VISIT_TIME BETWEEN date_sub(NOW(),interval 7 day) and NOW()