Re: Computing Age for Select Query

2003-08-30 Thread Noah Davis
OK, really I should have RTFM closer on this one (at least the tutorial section). http://www.mysql.com/doc/en/Date_calculations.html even has a part about computing ages. However, I guess my original question remains, which is, is there a better, cleaner way to do it than this, which computes the a

Computing Age for Select Query

2003-08-30 Thread Noah Davis
I'm writing a SQL query that returns a set of users based each user's mutual matching preferences. Picture a dating service, where one user is 35 looking to meet 25-35 year olds, and another (matching) user is 25 looking to meet 30-35 year olds. The relevant fields in the user table would be: d