Select Old Accounts (60 Days)

[xProteuSx]

I am trying to do something like this:

 

SELECT * FROM mytable WHERE user_date_visit > DATE_SUB(user_date_visit, INTERVAL -60 DAY)

 

Essentially I have a members table and I have their last login in the following format:

 

YYYY-MM-DD

 

I would like to select all data for all members who have not logged in in the last 60 days.  I keep on playing with the MySQL query, but I just can't get it to work.  It always either selects all the members or none of them.

 

Some help would be appreciated ...

 

Cheers.

[xProteuSx]

Ofcourse ...

 

 

12 seconds later it works:

 

SELECT *

FROM my_table

WHERE user_date_visit < DATE_SUB( NOW( ) , INTERVAL 60 DAY )