find inactive users

[ankush]

I am storing last login time of user in users table, I want to get all the users inactive from 10 days anyone help with the query.

[james438]

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.