count inserted records for a specific day of the week
I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period.
More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the week being Monday.
My date field in mysql is formated as 0000-00-00 00:00:00
Any thoughts on this is appreciated