> Is there any chance at all that a field name is appearing in your > WHERE clause? For example: > > UPDATE foo SET flag = 0 WHERE foo_id = foo_id; > > foo_id = foo_id of course matches all.
No, the query is hard coded to "WHERE Sent = 0". > Not much room for that kind of error in this example, but > perhaps in other scripts that deal with the table in question? No other scripts perform UPDATEs on that table, only INSERTs. But MySQL returned the correct data at 8:55 and again at 9:05. It was only when it ran at 9am that it appeared to ignore the WHERE. According to my binary log, the Mail table wasn't changed at all during this time - so the results of all three queries should have been identical. --Mike --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
