The MySQL Equivalant of SQL Server’s ISNULL Function

It’s called IFNULL and it works like this:

IFNULL(expr1,expr2)

If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. IFNULL() returns a numeric or string value, depending on the context in which it is used.

My search terms:

  1. mysql null into blank
  2. mysql null into blank function

Posted by Greg Pinero (Primary Searcher) on May 6th, 2007 and is filed under Other.

Both comments and pings are currently closed.

Add this post to Del.icio.us - Digg

Comments are closed.