Returns only rows where grp = 'C' and not undefined
> Similar behaviour with LIKE and IN
> >Fix:
> Puzzled?
> Am I not understanding something?
>
> >Submitter-Id:
> >Originator: Kevin McManus ([EMAIL PROTECTED])
> >Organiza
**
-Original Message-
From: Gonzo McMuppet [mailto:gonzo@;raq566.uk2net.com]
Sent: November 1, 2002 16:29
To: [EMAIL PROTECTED]
Subject: behaviour of WHERE clause with empty fields
>Description:
Empty fields are not matched using where clause
NOT IN
NOT L
Park Row
Greenwich
London SE10 9LS
>
>MySQL support: none
>Synopsis: behaviour of WHERE clause with empty fields
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.41 (Source distribu