Add another field in place of month(due_date) and index that. It may be better to use a field that contains the year as well, e.g. YYYYMM, since due dates also have a year component.
--- mike t. ----- Original Message ---- > From: joebert jacaba <[EMAIL PROTECTED]> > To: Philippine Linux Users' Group (PLUG) Technical Discussion List > <[email protected]> > Sent: Tuesday, January 15, 2008 12:59:09 PM > Subject: Re: [plug] Large MySQL table > > > select > count(*) > from > table > where > month(due_date)=month(now()); _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
