In article <[EMAIL PROTECTED]>, matt_lists <[EMAIL PROTECTED]> writes:
> 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" If those "other databases" return also NULL values, they're broken. > but in mysql, it wont work if there's null records in the table > I have to do this, select from table where ( col <> 'blah or isnull(col) ) Yes, of course. "NULL <> 'blah'" returns NULL, and that's perfectly standards-conformant. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
