Skip to content

Databases and queries

What is the MySQL SELECT syntax for a conditional expression?

lichen20 Sept

The conversation continues 2 ↓

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 MEMBER

The 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?

The conversation continues 2

Follow the reasoning

SELECT MEMBER_ID,
  (CASE MEMBER_ID WHEN 2 THEN 1 ELSE 0 END) AS IS_CHOSEN
FROM MEMBER

ed_fern20 Sept Permalink
```
SELECT MEMBER_ID, IF(MEMBER_ID = 2, 1, 0) AS IS_CHOSEN
FROM MEMBER
```
The IF() construct (https://dev.mysql.com/doc/refman/8.0/en/if.html) behaves much like the ? : ternary operator.

Other sides of the same question

Databases and queries
Missing field through a derived table in SQL
I'm executing the following SQL statement: It produces the following error: #1054 - Unknown column 'shipping.post_id' in 'on…
ed_fernReplies 2Latest activity 13 hours agosql
Databases and queries
Testing D arrays for a matching entry
with associative arrays this is possible how is this done with ordinary arrays? I'd like a validation expression, for example
pothosReplies 2Latest activity 13 hours agod
Databases and queries
Removing an optional column safely with PostgreSQL 9+
I want to remove a column belonging to a table. What's the way to determine whether that column is present? I read the manual…
JunReplies 2Latest activity 13 hours agosql