Web lists-archives.com

Re: find any row with NULL

----- Original Message -----
> From: "lejeczek" <peljasz@xxxxxxxxxxx>
> Subject: Re: find any row with NULL

> ok, whereas that fist example was about all (and find
> columns' names without knowing) columns - would there be a
> simple(r) syntax to find that (not)NULLs in a list of given
> column names? Or it has to be multiple ORs ?

Alas, no. If you're handling NULLvalues, all you have is <column> IS NULL and <column> IS NOT NULL. No other operators work.

Unhappiness is discouraged and will be corrected with kitten pictures.

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql