On Jan 22, 2008 7:18 PM, Mont McAdam <[EMAIL PROTECTED]> wrote: > In my opinion it should return every record from the table where `method` is > equal to NULL, ZERO or EMPTY STRING, as this table doesn't allow null, and > the field type is varchar, this would be EMPTY STRING's only.
Although it doesn't matter here because of the NOT NULL, this will never match NULL values. NULL values are neither true nor untrue, so they have to be checked with IS NULL. This is standard, not a MySQL thing. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
