mySQL: Replace a NULL with a given value. - Replace a NULL with a given value.<br />

Quick Search:

mySQL: Replace a NULL with a given value.

Jump to:

Snippet Name: Replace a NULL with a given value.

Description: Replace a NULL with a given value.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT age, name, COALESCE(city, 'No City Listed') 
FROM users