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 votes113 views2 answers
Change mysql password from command line
SQL
5 votes100 views1 answer
Oracle drop index if exists
SQL
0 vote106 views4 answers
Rownum in sql
SQL
1 vote109 views4 answers
Mysqldump 1 table only
SQL
4 votes120 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote123 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
48 votes164 views3 answers
Psql create database
SQL
0 vote98 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote93 views1 answer
Is numeric in sql
SQL
0 vote93 views1 answer
Sql show all users
SQL