`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 <[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. > > > > > >" 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
