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

2 votes132 views1 answer
Find all triggers in database
SQL
12 votes127 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote142 views1 answer
Sql ignore
SQL
1 vote150 views1 answer
How to run parallel queries in sql server with entity framework
SQL
2 votes140 views1 answer
Metasploit start postgresql
SQL
6 votes127 views4 answers
Sqlite drop table
SQL
1 vote143 views1 answer
Mysql month name extract
SQL
0 vote136 views1 answer
Selecting duplicates
SQL
0 vote120 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote141 views3 answers
Duplicate row mysql
SQL