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

1 vote150 views1 answer
Declare variables sql
SQL
1 vote161 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote159 views1 answer
Mysql query bulk insert
SQL
0 vote148 views1 answer
Oracle exchange subpartition
SQL
3 votes144 views3 answers
Mysql select table names
SQL
0 vote137 views1 answer
Mysql add to value
SQL
1 vote172 views1 answer
Hangfire clear all jobs
SQL
7 votes156 views2 answers
Phpmyadmin change password
SQL
0 vote138 views1 answer
Create schema sql server
SQL
24 votes156 views6 answers
Replace mysql
SQL