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]

Reply via email to