for selecting dates during a year, use BETWEEN with a range of dates rather than the YEAR() function: this allows the database to take better advantage of indexes
for selecting dates during a year, use BETWEEN with a range of dates rather than the YEAR() function: this allows the database to take better advantage of indexes

cacqw7/set_builder,ben5516/set_builder,boblail/set_builder,cacqw7/set_builder,boblail/set_builder,cacqw7/set_builder,boblail/set_builder,ben5516/set_builder,ben5516/set_builder