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
Create or replace view postgress
SQL
2 votes252 views1 answer
Mysql now format
SQL
11 votes224 views2 answers
Sql rank
SQL
0 vote224 views1 answer
Oracle enable chain
SQL
0 vote241 views1 answer
Azure sql server check foreign key
SQL
0 vote245 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote228 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote237 views1 answer
ORACLE PARSE STRING
SQL
7 votes244 views2 answers
Sql empty table
SQL
0 vote262 views2 answers
Disallowed function mysql to_date()
SQL