MySQL for devs Archives - Federico Razzoli

NULL comparisons in MySQL, PostgreSQL, and SQLite

Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.

MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs.