MySQL Select Date comparisons functions? features?

[rice]

Hello friends,

I was wondering if there anyway to Select rows where the date column falls into a certain range?

For example, heres a table

Code:
The date field is generated automatically by MySQL with the DATE function

Heres the table:

[user] . [wins]. [date]
bobby.......4..... 2006-08-21
boby1.......3..... 2006-08-22
boby2.......6..... 2006-08-24
boby3.......1..... 2006-08-29
Now I need to filter this data out so that I can have the end user browse weekly results. I'm stuck on a SELECT syntax statement that can pull any rows from any dates ranging from 8-21 to 8-27 (Monday to Sunday this month).

If this was the case, the last row , boby3 who has 1 wins on 08-29 will not be displayed for this current week's result.

I already have this which ranks users OVERALL season wins:
SELECT user, sum(wins) from results GROUP BY user ORDER by wi -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[gibson]

Code:

select user
, sum(wins) as wins
from results
where `date` between '2006-08-21' and '2006-08-27'
group
by user
order
by wins


Cheers -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --