On 28 Jan 2010, at 11:09, Lonnie Olson wrote:
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?
It did in the original logic. The requirements just changed though. I am posting an update. Thanks.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
