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

7 votes200 views3 answers
Python and mysql connectivity
SQL
1 vote205 views1 answer
Regular expression in sql server
SQL
0 vote177 views1 answer
Sql select maximum column with other columns returned
SQL
4 votes211 views6 answers
Sql select statement
SQL
1 vote232 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote196 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote190 views1 answer
How to check default value of column in sql server
SQL
1 vote360 views1 answer
Athena query timestamp greater than
SQL
2 votes183 views1 answer
Sql server check for value in multiple columns
SQL
-1 vote219 views5 answers
Left join
SQL