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 vote182 views1 answer
Android sqlite add column if not exists
SQL
5 votes177 views1 answer
Mysql last day of next month
SQL
0 vote185 views2 answers
Mysql two column combination unique
SQL
0 vote189 views1 answer
Dbms_output sql developer
SQL
2 votes192 views1 answer
Grant revoke privileges to mysql username
SQL
7 votes190 views1 answer
Oracle pagination query offset
SQL
8 votes172 views2 answers
Phpmyadmin default password
SQL
1 vote178 views1 answer
Mysql show current queries
SQL
0 vote178 views1 answer
How to print sql query
SQL
0 vote182 views2 answers
Return the number of records in a single table mysql
SQL