select t1.* from students as t1 ,(select name,borndate from students where name like '%佳文%') as t2
where datediff(year,t1.borndate,t2.borndate)>=1