That did the trick! Thank you!!
--- In [email protected], "Silviu Stafie" <[EMAIL PROTECTED]> wrote: > Use this query: > > SELECT * FROM table WHERE MOTNH(DateColumn)=MONTH(now()) and DAYOFMONTH(DateColumn)=DAYOFMONTH(now()) > > Good luck, > Silviu > ----- Original Message ----- > From: Jer > To: [email protected] > Sent: Tuesday, July 26, 2005 8:59 PM > Subject: [php_mysql] Current month date in SELECT > > > I've got a date column. And I want to compare the date column to the > current date and month...so that when the query runs, the rows with > the same date and month as the current day are returned. > > How do I do this? > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. > > > > ------------------------------------------------------------------------------ > YAHOO! GROUPS LINKS > > a.. Visit your group "php_mysql" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > ------------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------------ > > > > -- > This message was scanned for spam and viruses by BitDefender. > For more information please visit http://linux.bitdefender.com/ > > > [Non-text portions of this message have been removed] The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
