get resulsts between 2 dates

[Arc]

Hey guys i cant find this on the MySQl site.

I have a date field and I want to get results between 2 days. For instance

$low = "2006-04-01";
$high = "2006-04-31";
$sql = "SELECT * FROM tblJobs WHERE UserID = '$userID' AND JobStatus = 'Estimate' AND DateAdded BETWEEN ('$low' AND '$high')";

I am not sure how to work the BETWEEN clause in mySQL.

Thanks!

[dr_bung]

SELECT *FROM testWHERE date_added BETWEEN '2006-07-01' AND '2006-07-05'

SELECT * FROM test WHERE date_added >= '2006-07-01' AND date_added <= '2006-07-05'