----- Original Message ----- > From: "lejeczek" <pelj...@yahoo.co.uk> > 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