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 votes290 views1 answer
Remove spaces sql 2008
SQL
0 vote335 views1 answer
Mysql where don't have string
SQL
8 votes353 views6 answers
Sql insert
SQL
7 votes338 views2 answers
MySQL IF without else
SQL
0 vote292 views1 answer
Grant access on table in oracle
SQL
2 votes339 views1 answer
Mysql create user with remote access
SQL
0 vote322 views1 answer
SAP Return
SQL
0 vote312 views1 answer
Mysql not defined
SQL
1 vote277 views1 answer
Mysql get last insert id
SQL
0 vote305 views1 answer
Tsql default value when no value returned by query
SQL