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 vote101 views1 answer
Pl/sql loop example
SQL
0 vote95 views1 answer
Edit a field mysql terminal
SQL
3 votes103 views1 answer
RENAME table pl sql
SQL
0 vote101 views1 answer
Mysql DDL
SQL
0 vote112 views1 answer
Mysql grant user wildcard database
SQL
0 vote120 views1 answer
Set Mamp mysql globally
SQL
16 votes99 views3 answers
Tsql rename column name
SQL
1 vote108 views1 answer
Oracle case
SQL
0 vote219 views1 answer
Python get backup of sql
SQL
0 vote103 views2 answers
How to check if a column exists in a SQL Server table?
SQL