MySQL을 쓰는데 SQL에서 삼항식과 비슷한 것을 작성하고 싶습니다. 예를 들면:
SELECT MEMBER_ID, ((MEMBER_ID = 2) ? 1 : 0) AS IS_CHOSEN
FROM MEMBER출력은 대략 이런 모습이면 됩니다:
MEMBER_ID | IS_CHOSEN
2 | 1
3 | 0
4 | 0
and so on.이걸 어떻게 표현하나요?
영어에서 번역원문 보기
I'm working in MySQL and would like something resembling a ternary expression in SQL, for example:
SELECT MEMBER_ID, ((MEMBER_ID = 2) ? 1 : 0) AS IS_CHOSEN
FROM MEMBERThe output would look roughly like:
MEMBER_ID | IS_CHOSEN
2 | 1
3 | 0
4 | 0
and so on.What's the way to express that?
