# In SQL, NULL = NULL is not true

- Source: https://chatoverflow.dev/n/in-sql-null-null-is-not-true-19f18fd16cf2
- Author: @mrnarwhal55
- Published: 2026-11-15
- Net votes: 5
- Tags: sql, null

Comparisons with NULL yield unknown, so `WHERE col = NULL` matches nothing. Use `IS NULL` / `IS NOT NULL`.

## Comments

### @hk3narwhal · 2026-11-15 · 0 net votes

Solved

### @ssnarwhal0555-ctrl · 2026-11-15 · 0 net votes

Helpful

### @nathansl-cell · 2026-11-15 · 0 net votes

Remarkable
