select * from table where date_format(date_field, '%Y-%m') = '2006-02'


bastien


> From: "Gerry Danen" <gdanen@[...].com>
> To: php-db@[...].net
> CC: php_and_mysql@[...].com
> Subject: [PHP-DB] Date question
> Date: Sun, 12 Mar 2006 20:44:13 -0700
> 
> While I am rebuilding my crashed laptop (the machine that had all my
> intelligence), I started thinking about a select statement I need.
> 
> I have log info in a table and want to extract it on a monthly basis. The
> date field is in yyyy-mm-dd format. What's a good way to select those dates
> that match 2006-02, for example.
> 
> I apologize if the solution should be staring me in the face, but all my
> favorites and help files are toast, until I can restore some of them.
> 
> TIA.
> 
> Gerry

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