-Original Message-
From: Mont McAdam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008 7:18 PM
To: mysql@lists.mysql.com
Subject: Re: Did NOT condition on VARCHAR change with 5.0.45?
`method` is the name of the column in the table.
In my opinion it should return every
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
`method` is the name of the column in the table.
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.
This has always worked in the
Hi,
I am having a problem with MySQL 5.0.45 returning what I consider to be
unexpected results.
Basically I am attempting the following query, and ALL records are being
returned.
SELECT * FROM `jos_products_orders` WHERE NOT `method`
For the uninformed, what should this do according to you?
What is method mean in your sql statement?
On Jan 15, 2008 5:33 PM, Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
I am having a problem with MySQL 5.0.45 returning what I consider to be
unexpected results.
Basically I am attempting the following query, and ALL records are being
returned.