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 vote219 views1 answer
Sql select max value for each group
SQL
2 votes171 views1 answer
Install postgresql centos 5
SQL
0 vote182 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote143 views1 answer
Mysql case when null
SQL
1 vote141 views1 answer
Mysql check if string contains comma separated
SQL
0 vote148 views1 answer
Renommer table sql
SQL
18 votes151 views6 answers
Drop table if exists
SQL
0 vote188 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote139 views1 answer
Strat with in sql
SQL
1 vote153 views1 answer
Stored procedure return value
SQL