No that says that it can figure out the where and prob wont use a key. The like is probably the cause.
If it was going to use the primary key then the FIELD Key_used (something like that) would say PRIMARY. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED] -->Sent: Friday, September 19, 2003 2:12 PM -->To: [EMAIL PROTECTED] -->Subject: explain --> -->Hello, --> -->When I do a explain on a query, I got the following: -->+-----------------------------------------------------+ -->| Comment | -->+-----------------------------------------------------+ -->| Impossible WHERE noticed after reading const tables | -->+-----------------------------------------------------+ --> -->does this say that my query is using Primary key? --> -->Thanks --> -->Hsiu-Hui --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
