Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Mont McAdam (montplatformnetworks.net)
Date: Tue Jan 22 2008 - 18:18:02 CST
`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`.
> 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