Re: impossible WHERE noticed after reading const table

2002-07-08 Thread Egor Egorov
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:

impossible WHERE noticed after reading const table

2002-07-06 Thread Mike
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