title: How to select all elements from a table in sqlite where a value X is within a certain radius R from another value C?
body: <p>The table in question is very large, and this select function could be called very often over a short amount of time.</p>
  <p>As the title suggests, given a center integer value C and a radius integer value R, how can I access all rows within a db file such that the row integer values X in column Cx satisfy |x-C|&lt;R?</p>
  <p>i.e.</p>
  <ol>
  <li>| 15</li>
  <li>| 12</li>
  <li>| 17</li>
  <li>| 16</li>
  <li>| 13</li>
  <li>| 9</li>
  </ol>
  <p>C=10, R=3 =&gt; 2, 6</p>
  <p>Preferably ordered by closest to C value, but if not possible or it increases asymptotic time complexity then not necessary.</p>