Hi Max, You must enter this: SELECT * FROM your_table WHERE date LIKE "2003-01-%";
I think that you can more read about LIKE at http://www.mysql.org Best Regards, Boris Penchev ----- Original Message ----- From: "Max Clark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 12:27 AM Subject: Select Date Help > Hi all, > > I have a DATE column (CCYY-MM-DD), I would like to do a query like this: > > select * from table where date = '2003-01' > > What additional information do I need to provide for this query to work > properly? > > Thanks in advance, > Max > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php