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

8 votes197 views2 answers
Safe update mode in mysql
SQL
0 vote202 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote213 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote152 views2 answers
Spring properties file for db
SQL
0 vote259 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote192 views2 answers
How to update the multiple rows in sql
SQL
5 votes187 views2 answers
Mysqldump password
SQL
-1 vote195 views1 answer
Su: Authentication failure mysql
SQL
0 vote197 views1 answer
Oracle sql date summer time
SQL
13 votes274 views3 answers
Sql select from multiple tables without join
SQL