title: SELECT * FROM Table WHERE Col1, Col2 BETWEEN a AND b
body: <p>I have a table of different packages like this:</p>
  
  <pre><code>term package1 package2 package3
  1yr     1000     2000     3000
  2yr     1800     3800     5800
  3yr     2500     5500     7500 
  </code></pre>
  
  <p>Now I want to select all rows where value is between a and b.</p>
  
  <p>I tried using this:</p>
  
  <pre><code>SELECT * FROM Products WHERE package1, package2 BETWEEN 1000 AND 5000
  </code></pre>