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 vote260 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote283 views1 answer
Get initials name in sql
SQL
6 votes247 views1 answer
Sqlite foreign key
SQL
11 votes274 views3 answers
Pl sql example
SQL
0 vote295 views1 answer
Sql date with year
SQL
19 votes229 views1 answer
Sqrt(-1)
SQL
1 vote281 views2 answers
Foreign key set 0
SQL
0 vote292 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote274 views1 answer
Sql select random procentage from rows
SQL
24 votes307 views6 answers
Sql change table name
SQL