SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE 'Lucy, Ella, Pickle, Rogan, Sabrina, Mitty' LIKE CONCAT('%', NAME, '%')
ORDER BY ANIMAL_ID;
코드2 - WHERE OR, ORDER BY
SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE NAME = 'Lucy'
OR NAME = 'Ella'
OR NAME = 'Pickle'
OR NAME = 'Rogan'
OR NAME = 'Sabrina'
OR NAME = 'Mitty'
ORDER BY ANIMAL_ID