3. Handling the Null value

IS NULL

SELECT * FROM customer;

SELECT * FROM customer WHERE name IS NULL;

Equal to empty string

SELECT * FROM customer;

INSERT INTO customer (id, name, address, city, state, zip) VALUES (7, "Billy", NULL, "", "SG", NULL);

SELECT * FROM customer WHERE city = "";

IS NOT NULL

SELECT * FROM customer WHERE address IS NOT NULL;