SELECT * FROM TabloAdi WHERE tarih >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) ORDER BY id DESC
DATE_SUB(curdate(), INTERVAL 1 MICROSECOND) DATE_SUB(curdate(), INTERVAL 1 MINUTE) DATE_SUB(curdate(), INTERVAL 1 HOUR) DATE_SUB(curdate(), INTERVAL 1 DAY) DATE_SUB(curdate(), INTERVAL 1 WEEK) DATE_SUB(curdate(), INTERVAL 1 MONTH) DATE_SUB(curdate(), INTERVAL 1 QUARTER) DATE_SUB(curdate(), INTERVAL 1 YEAR)