[UPHPU] select records with date

[Lonnie Olson]

On Thu, Jan 28, 2010 at 10:21 AM, Wade Preston Shearer
<wadeshearer.lists at me.com> wrote:
>> Simple simplification here:
>>
>> SELECT * FROM Users u, User_Actions ua
>> WHERE u.id = ua.user_id
>> AND ua.date >= NOW() - INTERVAL 3 YEAR;
>>
>> This date math syntax is easier to read and understand.  It doesn't
>> require ADDDATE or anything.  Just a simple + or -
>
> This doesn't take into account the sign up date though.

Does it need to?  I guess I don't understand.  According to your first
post you wanted the records that occurred in the last 3 years, did it
not?