> -----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 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`. [JS] I'm running 4.1.22:
mysql> select "" = true; +-----------+ | "" = true | +-----------+ | 0 | +-----------+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
