Date Select Craziness

[Anon]

I need to select records based on a date. Or range of dates. The database contains date fields in the appropriate YYYY-etc format. The question is how can I select all records in the database given JUST the year value. ie, select from cases all records (all values) if it field date is 2002?

Any hints would be appreciated.

• bob

[[deleted]]

http://www.mysql.com/doc/D/a/Date_and_time_functions.html