Re: find any row with NULL
Johan De Meersman <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
----- Original Message ----- > From: "lejeczek" <[email protected]> > 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