We have created an audit table to records certain relevant actions taken by users of our application. The table has a primary key as well as a date/time stamp field to store when an action is taken. The interface that we use to view the audit table allows the user to select a date range. Say All Results between March 28 - 29 , 2007.
Will Mysql search the entire table to find values with those dates or is it smart enough to look only between the dates selected? Or is there a way to make it look at the entries between the dates selected?
Can someone point me in the right direction to allow me to gain a better understanding of how Msql works in relation to a date/time search.