SQL: is not null

update address set address_type = '8' where organization_id is null;

update address set address_type = '7' where organization_id is not null;