I have a table with several fields, the primary key
is a CHAR(11) field that does NOT allow NULL values. This field is called
rec_key. Now, when I attempt to run the following query:
SELECT * FROM table_name WHERE rec_key LIKE
'key_value'
it returns NO data.. If I drop EXPLAIN in front of
it, I get the response:
Impossible WHERE clause noticed after reading const
tables.
I am attaching a mysqldump of a portion of
the data so you can test this yourself...
This file has the complete table definition in it
along with the data..
Lee Willmann |
--------------------------------------------------------------------- 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