php - SQL: Get unique data between two dates -

hi using mysql table "student" has 4 columns:

 id name   date          studentid 1  john   2010-01-15      3 2  matt   2010-01-10      5 3  jane   2010-02-10      8 4  john   2010-02-11      3 5  matt   2010-02-11      5 6  jane   2010-02-11      8 

i want fetch new entries in table between 2010-02-10 , 2010-02-12. if student had previous entry in table query should not return value. in above case query should return both entries of jane since john , matt had entry each previous date specified.

this have not working:

select *  student  date(date)  between '2010-02-10' , '2010-02-12'  , date(date)  not between '0000-00-00' , '2015-02-09'; 

group by , having looking if want single record per student:

select * student    group name    having date(date) between '2010-02-10' , '2010-02-12'; 

or use subquery if want records:

select * student    date(date) between '2010-02-10' , '2010-02-12'   , name not in       (select distinct name student date(date) < '2010-02-10'); 

how works: subquery selects names have records prior date range, i.e. ones don't want in result. produces set ('john', 'matt'). main query selects records in given date range name not in ('john', 'matt').