From: Mont McAdam (montplatformnetworks.net)
Date: Tue Jan 22 2008 - 18:18:02 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

`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 past. However now EVERY row is returned
regardless of the contents of `method`.

Thoughts?

> What is method mean in your sql statement?
>
> On Jan 15, 2008 5:33 PM, Martijn Tonies <m.toniesstripped> 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.
> > >
> > >" SELECT * FROM `jos_products_orders` WHERE NOT `method` "
> >
> > For the uninformed, what should this do according to you?
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
> > &
> > MS SQL Server
> > Upscene Productions
> > http://www.upscene.com
> > My thoughts:
> > http://blog.upscene.com/martijn/
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
> >
> >

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]