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 vote236 views1 answer
Oracle for loop on list
SQL
0 vote241 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote232 views1 answer
Sql get number of days between two dates
SQL
1 vote232 views1 answer
Mysql add fields
SQL
3 votes265 views1 answer
Sql double index
SQL
2 votes218 views1 answer
Insert from table tsql
SQL
0 vote209 views1 answer
Automate mysql cli query
SQL
6 votes266 views5 answers
Oracle list tablespaces
SQL
1 vote222 views1 answer
Median mysql
SQL
3 votes220 views1 answer
Sql server check version
SQL