论坛 › MySQL运维 › mysql 俩周之内时间端查询

jonvi 发表于 2016-10-21 10:58:21

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 俩周之内时间端查询