Since it's a date field, it's a date comparison and the date that you
specify ('WWW') gets parsed by the optimizer as being the date '0000-00-00'
since it can't find any valid date information. This is different from if
it was to convert the date to a string and do a string comparison, which is
what you were expecting it would seem.
If you try this with the date field actually being a CHAR() field, it will
probably come back with no matches.
Thanks,
Andy Moyer
Jetson Direct Mail Services, Inc.
PHP Developer & Linux/MySQL Admin
---------------------------------------------------------------------
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
