On Wednesday 09 April 2003 19:20, shaun wrote: > I have a date field in my table (YYYY-MM-DD). Is it possible to retrieve > all the rows that occur in a given month i.e. April? mysql manual > MONTH() -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* It is the quality rather than the quantity that matters. -- Lucius Annaeus Seneca */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php