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
