<div>
You can check <a href="http://mysql.com" rel="ugc">http://mysql.com</a>&nbsp;for documentaion of how date indexes work if you want
</div>


You can check http://mysql.com [http://mysql.com] for documentaion of how date indexes work if you want

<div>
<div class="content wysiwyg-content">
Scenario:<br />
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. &nbsp;Say All Results between March 28 - 29 , 2007. <br />
<br />
Question:<br />
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? <br />
<br />
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.<br />
<br />
Thanks 
</div>
</div>


Scenario:
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. 

Question:
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.

Thanks 

Intelligent Date Time Search in Mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.