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 do
> -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
`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 pas
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
>
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
Hi there,
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` "
I have pasted table structure, and some sample da
