mysql 俩周之内时间端查询

selecttitle,like_count,create_timefromhousing_guidewherestatus=2andcreate_timebetweendate_add(now(),interval-15day)anddate_add(now(),interval-1day)orderbycreate_timedesc;