Try this:


SELECT ID, date, name FROM users WHERE date > CURDATE()-10;

date in the query above is a column name. You can read more about MySQL time and date functions here.