mysql date compairon in condition code example

Example: compare date mysql

SELECT *
FROM players
WHERE DATE(us_reg_date) BETWEEN '2000-07-05' AND '2011-11-10'