Posted on September 29, 2011October 18, 2011 by admin MySQL: date comparison Find records which are 2 or more years old $sql = "SELECT id FROM table t WHERE DATEDIFF(CURRENT_DATE, date) >= 730";$sql = "SELECT id FROM table t WHERE DATEDIFF(CURRENT_DATE, date) >= 730";