age twice, albeit for different users:
SELECT user_b.* FROM user AS user_a, user AS user_b WHERE
(YEAR(CURDATE())-YEAR(user_a.date_of_birth)) -
(RIGHT(CURDATE(),5)
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 30, 2003 4:31 AM
Subject: Computing Age for Select Query
I'm writing a SQL
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
