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 vote297 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote347 views1 answer
Oracle list index on table
SQL
61 votes570 views6 answers
Mysql add column
SQL
0 vote362 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
2 votes379 views1 answer
Ifnull postgres
SQL
0 vote409 views1 answer
Psql create usr
SQL
4 votes373 views2 answers
Installing sql on ubuntu
SQL
13 votes356 views5 answers
Sql default
SQL
0 vote363 views1 answer
Select amount weeks between two dates mysql
SQL
7 votes345 views2 answers
Get database size mysql
SQL