Re: find any row with NULL
- Date: Fri, 29 Jul 2016 17:12:27 +0200 (CEST)
- From: Johan De Meersman <vegivamp@xxxxxxxxx>
- Subject: 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