Thanks for the reply. I have tried the following:
select count(*) from history
where timeentry between "2012-02-03" and "2012-02-09"
and dayofweek(timeentry) = 3
However, I would like to specify that my beginning day of the week is Monday so therefore, if I'm looking for all of the visits that occurred on "Tuesdays" for the "past month", Tuesday would be represented by 2. Is this thinking correct?
Additionally, I really need the above statement to get the Average visits for Tuesdays for the past specified time period. My statement above does not really give me the average. So essentially, I need some guidance in that area as well.
Any further thoughts on this is appreciated!