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

0 vote91 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
18 votes83 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
-1 vote129 views3 answers
MAKE TABLE FIT in oracle sql
SQL
4 votes84 views1 answer
SQL find text in SP
SQL
2 votes81 views1 answer
Sql ends with string
SQL
0 vote80 views1 answer
Monthly Birthday SQL Query
SQL
42 votes107 views6 answers
Rename table sql server
SQL
10 votes83 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote76 views2 answers
Postgres another version
SQL
10 votes79 views1 answer
Oracle dependencies table
SQL