Re: Bug ?? combining NOT and like in where clause

2001-01-27 Thread René Tegel
"Tor-Erik Hagen" <[EMAIL PROTECTED]> Sent: Sunday, January 28, 2001 12:56 AM Subject: Bug ?? combining NOT and like in where clause > Tested on the following versions of mysql: 3.22.32, 3.23.31 on Linux > > Description: > "where not field like pattern" gives

Bug ?? combining NOT and like in where clause

2001-01-27 Thread Tor-Erik Hagen
Tested on the following versions of mysql: 3.22.32, 3.23.31 on Linux Description: "where not field like pattern" gives empty set, while "where field not like pattern" return what i expect How-To-Repeat: create table testtabell(test varchar(10)); insert into testtabell values('test.com')