[프로그래머스] Python 개발자 찾기 - MySQL

🔗 Python 개발자 찾기

🦈 MySQL 🦈

✨ 방법1 : OR ✨

SELECT ID
    , EMAIL
    , FIRST_NAME
    , LAST_NAME
FROM DEVELOPER_INFOS
WHERE SKILL_1 = 'Python'
    OR SKILL_2 = 'Python'
    OR SKILL_3 = 'Python'
ORDER BY ID;

 

🌟 방법 2 : IN 🌟

SELECT ID
    , EMAIL
    , FIRST_NAME
    , LAST_NAME
FROM DEVELOPER_INFOS
WHERE 'Python' IN (SKILL_1, SKILL_2, SKILL_3)
ORDER BY ID;