只有年份只能粗略计算年龄了,请参见下列语句select * from tblName where year(now())-birth between 18 and 22;
select * from [表名] where[出生日期字段名] between date_add(now(),interval -22 year) and date_add(now(),interval -19 year);按照出生年月日计算来取 小22大19的人