"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]
