title: Is there a performance difference between BETWEEN and IN with MySQL or in SQL in general?
body: <p>I have a set of consecutive rows I want to get based upon their primary key, which is an auto-incrementing integer. Assuming that there are no holes, is there any performance between between:</p>
  
  <pre><code>SELECT * FROM `theTable` WHERE `id` IN (n, ... nk); 
  </code></pre>
  
  <p>and:</p>
  
  <pre><code>SELECT * FROM `theTable` WHERE `id` BETWEEN n AND nk;
  </code></pre>