title: Select or print column values that don’t exist between two integers
body: <p>I have a list of about 10k sequential integer values that were supposed to be inserted into a table column from an external application. However, doing a COUNT() reveals that only 9900 were inserted.</p>
  
  <p>I need to determine which of the numbers in the sequence were NOT inserted.</p>
  
  <p>Using it the other way around is easy, just select from table column where value is BETWEEN x AND y, but I haven't figured out how to print (or select) the values that don't exist in the table column.</p>
  
  <p><em>EDIT: remove extranous '' from integers below</em></p>
  
  <pre><code>SELECT * FROM table 
  WHERE column1 = 'value'
  AND column2 BETWEEN 1 AND 10000
  </code></pre>
  
  <p>How can I print the value from the BETWEEN clause where column2 doesn't have value in range?</p>