At 14:51 -0400 10/25/04, matt_lists wrote:
I cant tell if this is a bug or a feature.
Select from table where col <> 'blah'
I use this all the time with other databases, works great, gives me
everything that's not "blah"
but in mysql, it wont work if there's null records in the table
That is the correct behavior.
I have to do this, select from table where ( col <> 'blah or isnull(col) )
You could use the <=> equality operator, which like like = except that it
also is true for NULL values:
NOT (col <=> 'blah')
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
