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 vote86 views1 answer
Flask_sqlalchemy install
SQL
25 votes127 views3 answers
How to use a database to see tables mysql
SQL
6 votes117 views3 answers
Update with inner join postgres
SQL
0 vote120 views1 answer
Learn sqlite dart
SQL
0 vote126 views1 answer
OFFSET consulta mysql
SQL
0 vote117 views1 answer
Sql server inner join convert collation
SQL
11 votes130 views2 answers
Having clause in sql
SQL
4 votes134 views1 answer
Sql data types
SQL
0 vote129 views1 answer
How to put value in parameters in mysqldataadapter
SQL
19 votes137 views6 answers
Mysql if null
SQL