Advertisements

Archive

Posts Tagged ‘isnull’

MySQL : coalesce in mysql


DESCRIPTION

The MySQL COALESCE function returns the first non-null expression in the list.

SYNTAX

The syntax for the MySQL COALESCE function is:

COALESCE( expression1, expression2, ... expression_n )

e.g.

SELECT COALESCE(t.col,1) FROM Table t

Above query will return 1 if t.col is null.

Hope this help !

Advertisements
Categories: Sql Server Tags: , , ,