This works perfect, Bastien! Many thanks. Gerry On 3/13/06, Bastien Koert <bastien_k@xxxxxxxxxxx> wrote: > > select * from table where date_format(date_field, '%Y-%m') = '2006-02' > > > bastien > > > >From: "Gerry Danen" <gdanen@xxxxxxxxx> > >To: php-db@xxxxxxxxxxxxx > >CC: php_and_mysql@xxxxxxxxxxxxxxx > >Subject: 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. >
