title: sql query greater than DATE (year) A but less than DATE (year) B
body: <p>I have a list of items like so:</p>
  
  <pre><code>Field: Name &amp; Field: DOB
  - David - 1962
  - Robert - 1955
  - Tracy - 1980
  - Bono - 1964
  - Betty - 1968
  </code></pre>
  
  <p>I need a simple SQL query that will return all name whose birth years ate in the 1960s (1960-1969). something along the lines of this logic:</p>
  
  <pre><code>$sql = "SELECT * FROM employees WHERE DOB =&gt; '1960' AND DOB =&lt; '1969' AND ORDER BY name";
  </code></pre>
  
  <p>FYI: Currently the DOB field in the employee database is a VARCHAR field with 4 character designation.</p>
  
  <p>Can someone point me to the correct syntax on such a query?</p>