How to calculate age on the fly during a select statement

Databases
1

Is there a way to calculate age on the fly during a select statement based off of a date of birth field?

2

this is what I have so far:
select name, year(date()-year(dob)) as age
from users;

3

here ya go ===> http://www.sitepoint.com/forums/showthread.php?358038-Selecting-people-with-a-certain-age-range-based-on-dob