SELECT count(*) as new_count FROM video WHERE registdate BETWEEN DATE_ADD(now(), INTERVAL -1 WEEK) AND now()
 

 

카드뉴스