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 vote177 views1 answer
For select oracle
SQL
1 vote144 views2 answers
Sql convert datetime to year month
SQL
2 votes144 views1 answer
Mysql clear screen
SQL
2 votes124 views3 answers
Mysql unix timestamp to date
SQL
13 votes156 views4 answers
Command line mysql import
SQL
15 votes148 views2 answers
How to know the username of postgresql
SQL
19 votes139 views6 answers
Laravel sql query
SQL
0 vote285 views1 answer
Sql change a colum to unique
SQL
1 vote148 views1 answer
Postgres count string length
SQL
2 votes149 views2 answers
Sqlalchemy return id after insert
SQL