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

16 votes163 views1 answer
Mssql int max value
SQL
3 votes159 views1 answer
Oracle revoke
SQL
3 votes161 views1 answer
Oracle apex message quit website
SQL
31 votes164 views3 answers
Sql count
SQL
13 votes166 views1 answer
Sql join 3 tables on id
SQL
1 vote162 views1 answer
How to see which columns are indexxed mysql
SQL
7 votes115 views1 answer
Mysql load data infile csv
SQL
0 vote174 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote154 views1 answer
Oracle table free space
SQL
0 vote138 views1 answer
Order by monthly in sql
SQL