Re: NOT problems

> >Here's my schema and data: > > > >create table person (name char(5)); > >insert into person values ('Bob'); > >insert into person values ('Jane'); > > > >In mySQL 4.1-alpha, 4.0.15a, and 3.23.58, I get the > >following results: > > > >mysql> SELECT * FROM person WHERE NOT name = 'Bob'; > >Empty

Re: NOT problems

At 11:37 -0700 9/30/03, Ed Smith wrote: Here's my schema and data: create table person (name char(5)); insert into person values ('Bob'); insert into person values ('Jane'); In mySQL 4.1-alpha, 4.0.15a, and 3.23.58, I get the following results: mysql> SELECT * FROM person WHERE NOT name = 'Bob'; E

NOT problems

Here's my schema and data: create table person (name char(5)); insert into person values ('Bob'); insert into person values ('Jane'); In mySQL 4.1-alpha, 4.0.15a, and 3.23.58, I get the following results: mysql> SELECT * FROM person WHERE NOT name = 'Bob'; Empty set (0.00 sec) mysql> SELECT * F