title: MySQL OR vs IN performance
body: <p>I am wondering if there is any difference with regards to performance between the following</p>
  <pre><code>SELECT ... FROM ... WHERE someFIELD IN(1,2,3,4)
  
  SELECT ... FROM ... WHERE someFIELD between 0 AND 5
  
  SELECT ... FROM ... WHERE someFIELD = 1 OR someFIELD = 2 OR someFIELD = 3 ... 
  </code></pre>
  <p>or will MySQL optimize the SQL in the same way compilers optimize code?</p>
  <hr />
  <h3>EDIT</h3>
  <p>Changed the <code>AND</code>'s to <code>OR</code>'s for the reason stated in the comments.</p>