In MySQL and other SQL dialects, NULL values have special properties.
Consider the following table containing job applicants, the companies they worked for, and the date they left the company. NULL indicates that an applicant still works at the company:
CREATE TABLE example
(`applicant_id` INT, `...
