mysql时间条件30天内_mysql选择30天范围内的日期

This must be simple but I fiddled with it, and didn't get anything I wanted. I have the following code:

SELECT id,title,start_date

FROM events

WHERE start_date > DATE_SUB(NOW(), INTERVAL 1 MONTH)

AND city = '$cityName'

ORDER BY start_date DESC

Now this selects events with dates in this month, but the definition of this month shown in query is different than what I need. I need it to show me events within 30 days and not only this month i.e. august. If I insert an event in august it shows the outcome. If I do insert september, it doesn't even though it is less than 30 days away.

解决方案

You should change 1 MONTH to 30 DAY:

WHERE start_date > NOW() - INTERVAL 30 DAY

To limit it to 30 days in either direction:

WHERE start_date > NOW() - INTERVAL 30 DAY

AND start_date < NOW() + INTERVAL 30 DAY