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 vote224 views2 answers
How to create a table from another table in sql derby
SQL
1 vote229 views1 answer
Epoch time converter in snowflake
SQL
4 votes209 views2 answers
Mysql how to change default charset
SQL
0 vote191 views0 answer
SQL
1 vote247 views5 answers
Postgresql difference between two dates in days
SQL
1 vote222 views1 answer
Postgresql pass array in function
SQL
0 vote233 views1 answer
Insert ip address in mysql
SQL
26 votes208 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote250 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote218 views1 answer
How to list function in psql
SQL