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

1 vote183 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
5 votes176 views1 answer
Postgresql functions
SQL
4 votes180 views2 answers
Oracle default date format
SQL
0 vote173 views1 answer
Psql list rules
SQL
1 vote193 views2 answers
Sql where is not number
SQL
0 vote221 views1 answer
Composit key in sql
SQL
0 vote390 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote171 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote186 views1 answer
Mysql terminal run sql file
SQL
2 votes191 views2 answers
Change mysql password from command line
SQL