MySQL Query to select data from last week? December 19, 2022 by Tarik select id from tbname where date between date_sub(now(),INTERVAL 1 WEEK) and now();