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 vote179 views1 answer
How to join result table in mysql
SQL
0 vote183 views1 answer
Snowflake drop column
SQL
0 vote175 views2 answers
Identity column in sql server
SQL
3 votes174 views5 answers
Sql select
SQL
5 votes211 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote149 views0 answer
SQL
0 vote212 views1 answer
Set Mamp mysql globally
SQL
1 vote150 views1 answer
Table infromation in sql server
SQL
0 vote192 views1 answer
How to drop a trigger in postgresql
SQL
6 votes219 views2 answers
WHERE value IS sql
SQL