IS NULL
SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL ORDER BY ANIMAL_ID ASC;
SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NOT NULL;
SELECT ANIMAL_TYPE, IFNULL(NAME,'No name')AS NAME,SEX_UPON_INTAKE FROM ANIMAL_INS