If mysql has a between function then you could try:
where date between '2002-12-01'and '2002-12-31'.
Otherwise try
where date > '2002-12-01 00:00:00'and date < '2002-12-31 23:59:59'
Regards

Peter Goggin
----- Original Message -----
From: "Matthew Moldvan" <[EMAIL PROTECTED]>
To: "'Max Clark'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 9:38 AM
Subject: RE: [PHP-DB] select date YYYY-MM mysql help


> Sounds more like an SQL question than PHP, but try the following:
>
> SELECT * FROM table WHERE date LIKE '2002-12%';
>
> Regards,
>     Matthew Moldvan
>
> ---------------------------------------
>  System Administrator
>  Trilogy International, Inc
>  http://www.trilogyintl.com/ecommerce/
> ---------------------------------------
>
> -----Original Message-----
> From: Max Clark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 02, 2003 5:40 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] select date YYYY-MM mysql help
>
>
> Hi all,
>
> I would like to do a query like this from mysql:
>
> select * from table where date = '2002-12';
>
> However unless I have the complete date '2002-12-26' the query doesn't
work
> correctly. What else do I need?
>
> Thanks in advance,
> Max
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>


----------------------------------------------------------------------------
----


> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to