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

4 votes264 views1 answer
To date oracle with time
SQL
1 vote271 views2 answers
Limit sqlserver
SQL
4 votes306 views1 answer
Sql select limit range
SQL
0 vote271 views1 answer
Copied text from internet not inserting in mysql
SQL
1 vote263 views1 answer
Varchar plsql
SQL
5 votes309 views1 answer
Get column name sql server
SQL
1 vote307 views1 answer
Get current date in pyspark sql
SQL
104 votes455 views2 answers
Like in mysql
SQL
-1 vote271 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote264 views1 answer
Sql server select ignore dupplicates
SQL