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

3 votes303 views1 answer
Mysql set field unique
SQL
14 votes314 views1 answer
Oracle new column
SQL
0 vote294 views1 answer
Criteria builder select subset of column
SQL
0 vote265 views1 answer
Select all domains of database firbird
SQL
0 vote311 views1 answer
How to add timestamp column in mysql
SQL
3 votes301 views1 answer
Pl sql escape &
SQL
0 vote313 views1 answer
Sql select upcoming birthdays
SQL
1 vote297 views1 answer
Tsql create unique index composite
SQL
2 votes291 views1 answer
Date_format for time sql
SQL
0 vote304 views2 answers
Create fulltext index mysql
SQL