On Thu, Jan 28, 2010 at 10:21 AM, Wade Preston Shearer <[email protected]> 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? _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
