This works perfect, Bastien! Many thanks.
Gerry On 3/13/06, Bastien Koert <[EMAIL PROTECTED]> wrote: > > select * from table where date_format(date_field, '%Y-%m') = '2006-02' > > > bastien > > > >From: "Gerry Danen" <[EMAIL PROTECTED]> > >To: php-db@lists.php.net > >CC: [EMAIL PROTECTED] > >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. >