title: What's mysql's "BETWEEN" performance over..?
body: <p>Is there any better performance when querying in (particularly) mysql of the following:</p>
  
  <pre><code>SELECT * FROM `table` WHERE `unix_date` BETWEEN 1291736700 AND 1291737300
  </code></pre>
  
  <p>over:</p>
  
  <pre><code>SELECT * FROM `table` WHERE `unix_date` &gt;= 1291736700 AND `unix_date` &lt;= 1291737300
  </code></pre>
  
  <p>or BETWEEN syntax is just being substituted with the second sql?</p>