On Thu, 2 Jan 2003 14:27:25 -0800, Max Clark wrote: >select * from table where date = '2003-01'
aside from ...where (date>='2003-01-01' and date <= '2003-01-31') I think you could use ...where left(date,7) = '2003-01' http://www.mysql.com/doc/en/Date_calculations.html - Steve Yates - To know recursion, you must first know recursion. ~ Taglines by Taglinator - www.srtware.com ~ --------------------------------------------------------------------- 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
