mysql compare date with now code example

Example 1: mysql compare datetime to another datetime

Select * From temp where mydate > '2009-06-29 04:00:44';

Example 2: compare date mysql

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