* Creative Solutions New Media > I have a table with a date field (called myDate for example) > formatted like xxxx-xx-xx. > > I want to do a query searching for all dates with the month of > August, for example. > > How would I do that?
SELECT datecol FROM mytable WHERE MONTHNAME(datecol)="August"; I suppose this would be slightly faster: SELECT datecol FROM mytable WHERE MONTH(datecol) = 8; <URL: http://www.mysql.com/doc/en/Date_and_time_functions.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
