If I do a "SELECT * from TABLE" I get all the records in the DB (as it should)
If I do a "SELECT id from TABLE" all the id's in the table are retrieved except id's 113-119 for some reason To use record 117 as an example: If I do a "SELECT * from TABLE WHERE id=117" it returns no records, but when I do the "SELECT * from TABLE" the record with id=117 shows up. id is an auto-increment int field "EXPLAIN SELECT * from TABLE WHERE id=117" says "impossible WHERE noticed after reading const table" what would cause this? The records that it can't find are recently added records. But I've added some since then using the same software and there's no issues. MySQL version 3.23.49-max-nt Thanks in advance, Mike Tiffee --------------------------------------------------------------------- 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
