That should be pretty easy to do, assuming you know SQL.
Let's say you want to find all records for March, 2001. That would be dates between 3/1/01 and 4/1/01. And let's assume your date column (where you store the actual dates) is called "DateCol".
Your query would look something like:
SELECT * FROM YourTable WHERE (DateCol >= 3/1/01 AND DateCol < 4/1/01)
This also assumes that your dates have been stored as "date" types, and not converted to string types. Comparing strings like this would make no sense.
The query will return all rows that meet the WHERE clause parameters.
I don't use MySql (I prefer to do all my DB processing off line using Visual Basic). So I don't know the exact MySql syntax, but I assume that you will need to set some sort of recordset variable, e.g.,
dim RS as recordset
You can then set RS = to what the query returns.
Hope that helps.
