SELECT * FROM users
WHERE birth_date = getdate();
UPDATE users
SET age = (SUM(select age from users where birth_date = getdate()) +1)
WHERE birth_date = getdate();
SELECT ("happy birthday" + lj_username + "!!!!!!!!") AS result
FROM users
WHERE modified_datetime = '6/22/2007'
1 row returned:
happy birthday
19aftermidnight !!!!!!!!