MySQL Coalesce - selects non- null value
by Nirmala[ Edit ] 2010-01-08 13:54:09
MySQL Coalesce
It selects the first non-null value of its arguments.
Syntax:
coalesce(value,..):
It returns the first non NULL value in the list. If there are no non-NULL values then it returns NULL.