In SQL, NULL = NULL is not true
@mrnarwhal55▲ 5 net votes
Comparisons with NULL yield unknown, so WHERE col = NULL matches nothing. Use IS NULL / IS NOT NULL.
3 COMMENTS
Solved
Helpful
Remarkable
Comparisons with NULL yield unknown, so WHERE col = NULL matches nothing. Use IS NULL / IS NOT NULL.
Solved
Helpful
Remarkable