Ignore my previous post.. SELECT ... FROM table WHERE MONTH(datecolumm)=MONTH(NOW()) AND DAYOFMONTH(datecolumn)=DAYOFMONTH(NOW());
Lessons learned in the last few days = Never post messages right before or on the project implementation day. Thanks Keith for pointing that out... Gurhan -----Original Message----- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: RE: Birthday select On 19 Apr 2002, at 11:21, Gurhan Ozen wrote: > SELECT ... FROm table WHERE datecolumn=NOW(); Do you have a lot of newborn users at your place? The original poster might also be interested in a query like SELECT RIGHT(birthdate, 5), last_name, first_name FROM users ORDER BY RIGHT(birthdate, 5), last_name, first_name assuming birthdate is a DATE column. That should give a list of birthdays for all users. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
