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 vote202 views1 answer
Get the next column of a table in mysql
SQL
11 votes193 views3 answers
Sqlite3 create table from another table
SQL
0 vote220 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote242 views1 answer
Oracle sql date winter time
SQL
6 votes202 views2 answers
Mysql interval 1 day
SQL
3 votes197 views3 answers
Postgresql random number
SQL
0 vote194 views1 answer
Show function mysql
SQL
0 vote229 views2 answers
Mysql show foreign keys
SQL
0 vote224 views1 answer
How to find symmetric pairs in sql
SQL
0 vote189 views1 answer
Restart sql server command line linux
SQL