[PHP-DB] NULL VALUE

[Perry, Matthew (Fire Marshal's Office)]

My "status" column in my Employee table should have two values "Active" and
"Inactive".  Right now all the active employees have the value "Active" and
the rest have a NULL value.

 

Why is it that the following commands do nothing?

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS != 'Active';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS <> 'Active';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS IS NULL';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS = '';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS = NULL;

 

- Matthew