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 votes129 views1 answer
Use of where in left join in mysql
SQL
0 vote125 views1 answer
How to reset AI in sql
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
1 vote130 views1 answer
Oracle case
SQL
0 vote154 views1 answer
In query in sql
SQL
5 votes136 views3 answers
MySql get fields of table
SQL
0 vote127 views1 answer
Mysql select where field like in list
SQL
8 votes122 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote143 views1 answer
Query archive mode
SQL
7 votes122 views3 answers
How to check table name in current database sql
SQL