mysql俩周以内时间端查询

mysql 俩周之内时间端查询 select title,like_count,create_time from housing_guide where status = 2 and create_time between date_add(now(), interval -15 day) and date_add(now(), interval -1 day) order by create_time desc;

mysql 俩周之内时间端查询
select title,like_count,create_time from housing_guide where status = 2 and create_time between date_add(now(), interval -15 day) and date_add(now(), interval -1 day) order by create_time desc;