mysql CURDATE + 100 days code example

Example: mysql date equals to current_date plus days

SELECT CURRENT_DATE - INTERVAL 30 DAY