I'm sorry I forgot to tell you that I'm trying to
Select something From tables Where birthday is Between 2002-02-02 and 2002-06-06
but I'm using mySQL and I'm not sure the between is working.
Between on mysql should work, here's an example of use:
select * from table_name where date between '2002-01-01' and '2002-02-02'
BETWEEN is just shorthand for >= and <= anyway so apart from readablility there isn't a need for it.