How to find list of people whose age is between a range?
<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>