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 vote246 views3 answers
MAKE TABLE FIT in oracle sql
SQL
11 votes218 views2 answers
Having clause in sql
SQL
-1 vote216 views1 answer
Can pandas fetch data from sql
SQL
0 vote208 views1 answer
Convert int to varchar sql
SQL
0 vote207 views1 answer
How to to get current date in sql
SQL
0 vote219 views1 answer
Write SQL in ruby on rails
SQL
8 votes199 views2 answers
Mysql query dates between two dates
SQL
6 votes213 views3 answers
Commit in sql
SQL
19 votes172 views1 answer
Sqrt(-1)
SQL
0 vote209 views1 answer
Str_to_date sql server
SQL