Re: Did NOT condition on VARCHAR change with 5.0.45?

[Moon's Father]

What is method mean in your sql statement?

On Jan 15, 2008 5:33 PM, Martijn Tonies <m.tonies@stripped> 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
>
>


-- 
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn