Is there a simple way of checking whether all the columns in a SELECT
are NULL? I know I can do the following:
SELECT c1, c2, c3 FROM t WHERE COALESCE(c1, c2, c3) IS NOT NULL
but this relies on specifying every column I've selected (which in my
actual code is a lot of columns that may change during development).
I was hoping there was a convenience syntax for checking whether all the
selected columns are NULL, without having to specify each column, e.g.
in pseudocode
SELECT c1, c2, c3 FROM t WHERE COALESCE(All_Selected_Columns) IS NOT NULL
Is there such a thing?
Thanks,
Yasir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
