search between date columns

[shuja]

i have table named as date and want to search records between two dates

structre

std |2010-09-11|2010-09-12|2010-09-13|...........
01 | p | P | P |.............

i want to retrieve data between colums 2010-09-05 and 2010-09-11 like

plz help me via giving any aidea r script...

[bradgrafelman]

Can you show us the actual table definition (e.g. by doing a "SHOW CREATE TABLE tableName" query)?