Mike, Saturday, July 06, 2002, 10:20:49 PM, you wrote:

M> If I do a "SELECT * from TABLE" I get all the records in the DB (as it M> should)

M> If I do a "SELECT id from TABLE" all the id's in the table are M> retrieved except id's 113-119 for some reason

M> To use record 117 as an example:

M> If I do a "SELECT * from TABLE WHERE id=117" it returns no records, but M> when I do the "SELECT * from TABLE" the record with id=117 shows up.

M> id is an auto-increment int field

M> "EXPLAIN SELECT * from TABLE WHERE id=117" says "impossible WHERE M> noticed after reading const table"

M> what would cause this? The records that it can't find are recently M> added records. But I've added some since then using the same software M> and there's no issues.

M> MySQL version 3.23.49-max-nt

Re-create indexes with myisamchk and try again.

M> Thanks in advance, M> Mike Tiffee