MySQL how to add days to column

Question

Here's the my query:

SELECT * 
FROM product 
WHERE product_created > NOW() ORDER BY product_created DESC

How can I add days to product_created?

Here's what I want to happen product_created+5days > NOW()

Thanks in advance..

Answer 1

You can use DATEDIFF:

SELECT * FROM product WHERE DATEDIFF(product_created,NOW() >= 5 ORDER BY product_created DESC

Answer 2

Simply, use DATE_ADD, see example below:

SELECT * FROM product WHERE DATE_ADD(product_created,INTERVAL 5 DAY)  > NOW() ORDER BY product_created DESC