Weird Query results.
Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below ID, Name, date, time 12345, , 11/02/02, 13:54 98384, bob1, 12/30/01, 04:16 88492, sally, 04/12/03, 01:01 99381, scott, 05/08/01, 08:19 Now when I do a lookup on the first returned records ID (12345) it turns out to be a record with a Name field value like zzJason If I further modify the query to the following; SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz% ID NOT LIKE 12345 I'll get the same results but with a different record that has a zzSomething value for the name field. Any ideas if this is a bug or if I'm doing something wrong in my query? Thanks, Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.*** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Weird Query results.
Jeff McKeon [EMAIL PROTECTED] wrote: Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below ID, Name, date, time 12345, , 11/02/02, 13:54 98384, bob1, 12/30/01, 04:16 88492, sally, 04/12/03, 01:01 99381, scott, 05/08/01, 08:19 Now when I do a lookup on the first returned records ID (12345) it turns out to be a record with a Name field value like zzJason If I further modify the query to the following; SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz% ID NOT LIKE 12345 I'll get the same results but with a different record that has a zzSomething value for the name field. Any ideas if this is a bug or if I'm doing something wrong in my query? Worked fine for me. Could you provide a repeatable test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Weird Query results.
Vitoria, Thanks for the feedback. I should have done this first but it turns out that there are actually bad records with: MobileName LIKE Mystery solved... Thanks, Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.*** -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:01 AM To: [EMAIL PROTECTED] Subject: Re: Weird Query results. Jeff McKeon [EMAIL PROTECTED] wrote: Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below ID, Name, date, time 12345, , 11/02/02, 13:54 98384, bob1, 12/30/01, 04:16 88492, sally, 04/12/03, 01:01 99381, scott, 05/08/01, 08:19 Now when I do a lookup on the first returned records ID (12345) it turns out to be a record with a Name field value like zzJason If I further modify the query to the following; SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz% ID NOT LIKE 12345 I'll get the same results but with a different record that has a zzSomething value for the name field. Any ideas if this is a bug or if I'm doing something wrong in my query? Worked fine for me. Could you provide a repeatable test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- 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]