Home >Database >Mysql Tutorial >mysql 俩周以内时间端查询
mysql 俩周以内时间端查询
- WBOYOriginal
- 2016-06-07 16:23:391123browse
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;
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL惯用函数 二Next article：ACCESS表达式生成器