Select where date relative to now()

mysql, sql

Solution

Use `INTERVAL`

SELECT * 
  FROM title 
 WHERE sales_end-date < DATE_ADD(CURRENT_TIMESTAMP, INTERVAL 30 day)

Problem

I am trying to find all results with an end date within 30 days of now. The query I am trying for is: ``` SELECT * FROM title WHERE sales_end-date < now() + 30 days ``` How would I do this properly?

Original source