MySql - How can I create a summary report of registrations per week.
Posted on 2009-04-02
I have a mysql database with a list of customers and a time stamp to show when they registered. I would like to produce a report that shows.
Week | Date Starting | Registrations
1 | 1/April/2008 | 20
2 | 8/April/2008 | 15
3 | 15/April/2008 | 6
The field is called "tStamp". Could somebody show me how to write the query?