Posted almost 9 years ago. Visible to the public. Repeats.
MySQL: CONCAT with NULL fields
In MySQL,
CopyCONCAT('foo', 'bar', NULL) = NULL
the NULL always wins in MySQL.
If you would rather treat NULL as an empty string, use CONCAT_WS (concatenation with separator) instead:
CopyCONCAT_WS('', 'foo', 'bar', NULL) = 'foobar'
PostgreSQL
In PostgreSQL the NULL is not viral in CONCAT:
CopyCONCAT('foo', 'bar', NULL) = 'foobar'
Check out our new e-book:
Learn to structure large Ruby on Rails codebases with the tools you already know and love.
