Tag Archives: NULLIF Function

MySQL COALESCE and NULLIF Function

Last updated on October 30th, 2018 at 04:25 amWe will be discussing MySQL COALESCE and NULLIF Function  in this post with lot of examples. COALESCE Function COALESCE Function in Mysql is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent to the following IF-THEN-ELSE statement IF val1 is not NULL THEN … Continue reading MySQL COALESCE and NULLIF Function »