Problem in Date selection

[sang]

Hi
I am working in mysql database system, i want to select the some fields with the date. For Example in a company employers details are stroed the is name, dateofjoin, age, Address etc. I want to select the particular employer those are joing in from date 'somedate' to 'somedate' .

mysql is

 create table emp_join(name varchar(20),join_date date,age int);
 
+------+------------+------+
| name | join_date  | age  |
+------+------------+------+
| sang | 2007-03-04 | 21   |
| xxx  | 2006-05-06 | 23   |
| yyy  | 2006-04-07 | 24   |
| zzz  | 2006-12-12 | 21   |
+------+------------+------+
 
 

From the above table i want to select the person who are join in the date (ie is the joing date is from 2006-05-06 to 2007-06-05

the result is displayed like this

sang
xxx

Please give the query to select the date 'fromdate' to 'todate'

Thanks and regards,
Sang

[dodjem]

You want something like this below?

SELECT name FROM emp_join WHERE join_date BETWEEN 'fromdate' AND 'todate';

or

SELECT name FROM emp_join WHERE join_date >= 'fromdate' AND join_date <= 'todate';

You just need to make sure that the fromdate and todate are in the correct date datatype format