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 vote234 views1 answer
How much space does sql server take per row
SQL
1 vote246 views1 answer
Key validation sql
SQL
1 vote221 views1 answer
Myql find duplicates
SQL
7 votes203 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote254 views1 answer
Postgresql remove new line from string
SQL
3 votes210 views3 answers
Stop mysql service ubuntu
SQL
0 vote203 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote203 views1 answer
Min salary in sql
SQL
15 votes208 views2 answers
How to know the username of postgresql
SQL
0 vote196 views1 answer
Postgresql parse json array
SQL