> I have the following table (complete with sample data).
> When I run the query below on a mysql 4.1.14 system, the only row
> returned is row 4 as expected.
> However, when I run the same query on a mysql 5.0.19 system, I get
> rows 2, 3 & 4; which is not what I would expect.
> I have found that if I replace the "date_add( Reminder_Sent, INTERVAL
> 7 DAY )" with a hard coded '2006-01-15', then I get the expected row 4
> only, but that defeats the object of the query as the dates in
> Reminder_Sent are not normally always the same.
> Can anyone point me to what is going on here?
> Paul Lautman
> CREATE TABLE `balls_in_play2` (
> `Ball_Number` tinyint(2) NOT NULL default '0',
> `Name` varchar(50) NOT NULL default '',
> `email` varchar(50) NOT NULL default '',
> `Expiry_Date` date NOT NULL default '0000-00-00',
> `Reminder_Sent` date NOT NULL default '0000-00-00',
> PRIMARY KEY (`Ball_Number`)
> ) ENGINE=MyISAM DEFAULT CHT=latin1;
> -- Dumping data for table `balls_in_play2`