Subtract month and day mysql

using DATE_SUB ^[docs] like :

DATE_SUB((DATE_SUB(curdate(), INTERVAL 1 MONTH)), INTERVAL 4 DAY)

SELECT DATE_ADD(DATE_ADD(NOW(),INTERVAL -1 MONTH), INTERVAL -4 DAY)

Keep it simple:

SELECT CURDATE() - INTERVAL 1 MONTH - INTERVAL 4 DAY;

or

SELECT '2014-03-27' - INTERVAL 1 MONTH - INTERVAL 4 DAY;

or if you like to preserve the current time:

SELECT NOW() - INTERVAL 1 MONTH - INTERVAL 4 DAY;

(Tested on MySQL 5.1.73 and newer)