Neil,
I would start with something like this, assuming the date column is called "d":
SELECT <count, or sum, or whatever aggregate function>
FROM <table>
GROUP BY d - INTERVAL DAYOFWEEK(d) DAY;
- Baron
On Thu, Apr 29, 2010 at 8:12 AM, Tompkins Neil
<neil.tompkins@stripped> wrote:
> Hi
>
> We need to produce a query to return the total number of user visits between
> two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29.
> My question is how can I compute the totals for each week within a query ?
> for example
>
> 2009-04-29 to 2009-05-06 100 visits
> 2009-05-07 to 2009-05-14 250 visits etc
>
> Cheers
> Neil
>
--
Baron Schwartz
Percona Inc <http://www.percona.com/>
Consulting, Training, Support & Services for MySQL
