Is this what you're looking for? SELECT id, datecol, text FROM table WHERE MONTH(datecol) =$mySelectedMonth;
----- Original Message ----- From: "H Bartel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 10, 2004 11:34 AM Subject: Select month from Date > Hi, > > I am trying to start using the mySQL Date functions instead of the unix > timestamp from PHP. I have read the man page several times now, but > still haven't come up with a solution for this simple query: > > SELECT id, datecol, text FROM table WHERE month-in-date-col = > $mySelectedMonth; > > This shouldn't be too hard, I guess, but it seems I'm missing something > here? Any help greatly appreciated. > > Regards, > Holger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]