Select where date relative to now()

Question

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?

Answer 1

Use INTERVAL

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