Re: Weird Query results.

[Victoria Reznichenko]

"Jeff McKeon" <jmckeon@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com