Mysql if example

Mysql if

SELECT user_display_image AS user_image,
       user_display_name AS user_name,
       invitee_phone,
       (CASE WHEN invitee_status = 1 THEN "attending"
             WHEN invitee_status = 2 THEN "unsure"
             WHEN invitee_status = 3 THEN "declined"
             WHEN invitee_status = 0 THEN "notreviwed"
       END) AS invitee_status
  FROM your_table

-1

Source: stackoverflow.com

Similar codes

1 vote316 views2 answers
Oracle leftmost characters
SQL
0 vote276 views1 answer
Select top 3 sql
SQL
12 votes309 views2 answers
Insert multiple rows from another table sql
SQL
1 vote343 views1 answer
Delete dublicate rows sql
SQL
0 vote290 views1 answer
Table or view does not exist
SQL
0 vote279 views1 answer
Reading from right to left from string find first special characters in sql
SQL
10 votes246 views2 answers
Django mysql
SQL
0 vote296 views1 answer
How to get parent and child record in single query using sql
SQL
5 votes305 views3 answers
Show indexes mysql
SQL
21 votes288 views4 answers
Oracle add column
SQL