find inactive users

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.

Try this:

Code:

---

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.