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 vote391 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
1 vote395 views1 answer
Oracle create program if not exists
SQL
0 vote337 views1 answer
Check for directory in bash
SQL
0 vote337 views1 answer
If null don't update
SQL
0 vote367 views1 answer
Sql cnvert bit to nvarchar
SQL
10 votes405 views2 answers
Doublon sql
SQL
0 vote389 views1 answer
See the structure of a table mysql
SQL
0 vote349 views1 answer
Mysql update set sum
SQL
0 vote346 views1 answer
How to set all the min and sec data to zero in sql server
SQL
3 votes346 views1 answer
Oracle apex warn on unsaved changes
SQL