我在用 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?
