title: How to find list of people whose age is between a range?
body: <p>I have this situation where I have date-of-birth stored in database eg. 1990/03/15. I want to find out info. of records whose age is between 20 &amp; 30. How should I write this query?</p>
  
  <p>I have tried this:
  I get age of all candidates using this query:</p>
  
  <pre><code>SELECT TIMESTAMPDIFF(YEAR,dob,CURDATE()) as age FROM `profile`
  </code></pre>
  
  <p>How to use it to get list of all candidates between age 20 &amp; 30?</p>